Calculate hours

[Sarah]

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,

 

[Bob Phillips]

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)

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,