How can I calculate hours in a Hourly schedule in Excel?

S

SUPERNAM

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
 
R

Roger Govier

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)
 
B

Bob Phillips

=(B2-A2)+(D2-C2)

will give 16:30. If you want it as decimal, just multiply by 24.
 
S

SUPERNAM

Thanks very much

Roger Govier said:
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 said:
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
Click to expand...
Click to expand...
 
Top