A question of time

M

Marsh

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
 
G

Gord Dibben

You have to let Excel know it is "next day"

2/2/2010 23:30 in I5

2/3/2010 1:00 in J5


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Amending meeting cancels all future meetings 0
Aggregate the time data (mm/dd/yyyy:hh:mm:ss) into the 3 hours range 0
Is there an Excel Function that can be used in lieu of this formul 5
REINSTALLING MS OFFICE PRO PLUS 2019 0
Showing 24 hour time along X-axis 0
Subtracting time...again 2
Time within time 8
If C2 is Sunday how do I make D 2 to the next day of the week 2

Top