Calculating timesheet with overtime

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

Guest

I'm trying to make a self calculating timesheet using formulas. So I can
enter in Mon-Sun amount of hours & they will automatically calculate "Reg" &
"OT". I have the "Reg" but I'm trying to figure out how to make anything
over 40 hours fall into the OT column.
(I.E.: Mon-Sun 8 hours per day=56 hours total, I want 40 hours to fall
under Regular time column & 16 hours to fall under the Overtime column).
 
Let's assume your total hours worked for the week are in cell A1.

Formula for Regular Hours: =MIN(A1,56)

Formula for Overtime Hours: =MAX(A1-56,0)

HTH,
Elkar
 
Back
Top