Subtracting times.

hi,

The formula does work well. However, if i have a situation of start time at 19:00pm and end time at 1:00am (past midnight). The result should be 6 hr but it return a value of 17. is there any formula to accommodate this?

Hi,

I have a problem when I do sums of hours for whole month. The number goes beyond 12 hours. What have I to do to have total number of working hours (biger number than 12). Thanks

THIS IS GREAT, BUT NOW HOW DO I GET THE TOTAL HOURS FOR ONE WEEK? THE =SUM THING DOES NOT WORK (SORRY, JUST LEARNING ALL THIS...)

hi...m trying to calculate flight times....
i have departing time from one city and i have to calculate the arrival time in another city....which means i have to take time zone difference in account...thanx a bunch

Problem:

Finding the difference between each two time values in columns A:B, by subtracting the earlier time from the later one.

Solution:

Using an IF statement to determine which of the two values is the earlier time, and subtract accordingly:
=B2-A2+IF(A2>B2,1)



Example:

Time1___Time2____Result
10:00___17:00____7:00
17:00___9:00_____16:00
12:00___15:00____3:00

Hope this helps with your problem.

=G10-F10+IF(F10>G10,24)