Timesheet calculation

  • Thread starter Thread starter Alan North
  • Start date Start date
A

Alan North

I am trying to create a timesheet for my staff and want
to calculate the hours worked as a time so the staff can
enter time started in one cell, time finished in another
and the spreadsheet to calculate the difference in time
in a third cell.

Also how would we cover lunchtime.

any help would be appreciated

Alan North
 
A couple of ways

start in A1, out for lunch in B1, back from lunch in C1 and end in D1

=MOD(D1-A1-(C1-B1),1)

start in A1, end in B1, number of minutes as an integer in C1

=MOD(B1-A1,1)-C1/1440

the only reason I use MOD is if your employees work after midnight, if not
use

=D1-A1-(C1-B1)

or

=B1-A1-C1/1440

format result as hh:mm

if you need to return payment based on the rate use

calculated_time*24*rate_per_hour

format as currency

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Back
Top