5
How to calculate difference between hours in Excel when it exceeds 24 hours?
Example:
A1 = 05/01/2016 11:40:53
B2 = 06/01/2016 12:29:53
B2-A1 = 24h:49min
But he returns 00:49
1 answer
9
It is a problem in formatting the cell that is storing the result.
If you leave the formatting as "number" the cell will display 1,03403 (depending on the number of decimal places you asked to display). If you leave the formatting as "date and time" a possible result will be 1/1/00 0:49, already within the "time" type formatting options you can consider only the time difference or also take into account the days difference.
You are choosing this option:
Choose this:
Browser other questions tagged excel datetime
You are not signed in. Login or sign up in order to post.
How are you doing the calculation? with code or using the excel tool to add/subtract? I don’t see the programming part in the problem you’re presenting.
– Sergio