How can I calculate hours in a Hourly schedule in Excel?
Thanks very much
"Roger Govier" wrote:
Hi
One way
=MOD(B1-A1,1)+MOD(D1-C1,1)
format the cell with the result as [h]:mm as this will allow it to sum
past 24 hours if necessary.
Using the MOD function in this way, will also deal with any cases where
end time is less than start time (e.g. from 4:00 PM today through till
8:30 AM tomorrow)
--
Regards
Roger Govier
"SUPERNAM" wrote in message
...
I have a schedule as
From To From To
7:30 AM 4:00 PM 8:00 AM 4:00 PM
What formula do I use to get the result 16.5?
Thanks
|