Excel Sum formula for timesheets.

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

Guest

I work in a very small office and manual fill in time sheets on a weekly
bases but I can't figure out the simple formula to add clock in, lunch out,
lunch in and clock out on a daily bases per employee.
 
To get time interval between two times simple take one time from another

So "Lunch out" - "Clock in" is time prior to lunch (?)

and

"Lunch in" - "Clock out" is time after lunch

so if A1=Clock in and B1=Lunch out, then E1 (for example) =B1-A1

Format cells as hh:mm or if time period is more than 24 hours, use [h]:mm in
the cells containing the calculation formulae

HTH
 
Back
Top