Calculate hours

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I just want to know how to calculate hours, if a worker clock-in at 8:00am and clock-out 5:35pm, what is the fomula to calculate total hours worked,
 
If you want it as time, subtract the earlier from the later and format the
result cell as hh:mm. If you want decimal hours, still subtract the earlier
form the later and m ultiply by 24, and format as General.

So simply
=B1-A1
or
=(B1-A1)*24

If the times overlap midnight then use
=MOD(B1-A1,1)
or
=MOD(B1-A1,1)*24

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Sarah said:
I just want to know how to calculate hours, if a worker clock-in at 8:00am
Click to expand...
and clock-out 5:35pm, what is the fomula to calculate total hours worked,
 
Back
Top