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

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

--
Kind regards,

Niek Otten

"Ewak@job1usa" wrote in message
...
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

"Ewak@job1usa" wrote:

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