Calculating timesheet with overtime

[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).

 

[Niek Otten]

http://www.cpearson.com/excel/overtime.htm

 

[Guest]

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