formula to calculate time difference crossing midnight
On Thu, 17 Aug 2006 07:16:03 -0700, ditorejax
wrote:
In Excel I have been trying to find an easier way to calculate a time
difference where the times cross midnight. Example:
Start time: 23:50:00
End time: 00:15:00
How would you formulate an equation to determine the duration of time or
differnce between the start and end time?
One way which results in hours and decimal of an hour is
=IF((end-start)<0,(end-start)*24+24,(end-start)*24)
If you want to see hours and minutes you'd need to modify it to pick
up the decimal fraction and multiply it by 60.
HTH
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
|