crossing midnight
Posted by Julie on July 18, 2001 9:43 AM
How do I get Excel to calculate the following:
Start Time = 23:00 Monday
Stop Time = 02:00 Tuesday
The difference would be 3 hours
Thanks!
Posted by Aladin Akyurek on July 18, 2001 9:53 AM
=Stop Time + (Stop Time < Start Time) - Start Time
Substitute the cell refs for these times and custom format the cell of this very formula as [h]:mm.
Aladin
Posted by Julie on July 18, 2001 11:40 AM
Thanks, works great! But I don't understand why it works?
Posted by Aladin Akyurek on July 18, 2001 12:28 PM
Julie,
The formula came up in earlier thread, where I attempted to explain how/why it works. See for that:
22918.html and the follow-ups.
Aladin
