If I have the time 21:00 in cell I5 and 23:30 in J5, the formula =(J5-I5)*24
gives me the result 2.5. However if the time in J5 is changed to
1:00(representing the next day) how do I get Excel to recognize that I am
going into the next day.
Right now I am getting a result - 20.0
I do remember seeing this somewhere but now I can not find it
Thanks