Time period spanning midnight
Enter the times as TIMES
A1 = 21:30
B1 = 3:45
What is the neatest formula to calculate the number
of hours between them?
=MOD(B1-A1,1)
--
Biff
Microsoft Excel MVP
"Stephen White" wrote in message
...
I am working on a time sheet.
Suppose in cell A1 I have a start time and in cell B1 a finish time in a
24hr format (say for example 23:00 or just 2300) and suppose that the time
between them spans midnight. So the two values might be
A1 21:30
B1 3:45
What is the neatest formula to calculate the number of hours between them?
--
Stephen White )
|