Payroll calculation

[Ansylene]

I was wondering if someone could help me. I am trying to write an Excel
formula to calculate straight time/overtime in a spreadsheet. Straight
time in one cell, overtime in another. I tried the SUMIF formula, but
I don't think that's the right way to go. I would really appreciate
some help here. Thanks a bunch!

cells E11 thru K11 contain daily hours, L11 would show straight time
and M11 would show overtime

 

[Jim]

No need to reinvent the wheel. There are many free download of timesheet
templates/worksheets, starting with
http://office.microsoft.com/templat...igin=CT062100761033&CategoryID=CT062100761033
or do a Google search for Excel timesheets.

 

[Paul]

I was wondering if someone could help me. I am trying to write an Excel
formula to calculate straight time/overtime in a spreadsheet. Straight
time in one cell, overtime in another. I tried the SUMIF formula, but
I don't think that's the right way to go. I would really appreciate
some help here. Thanks a bunch!

cells E11 thru K11 contain daily hours, L11 would show straight time
and M11 would show overtime

I assume you mean that you want to sum cells E11:K11 to give the total
hours, showing the result up to (say) 40 in L11 and anything beyond that in
M11.

Formula for L11:
=MIN(SUM(E11:K11),40)

Formula for M11:
=MAX(0,SUM(E11:K11)-40)

 

[Ozzie]

What are the rules on OT? In California, any time after 8
hours in a day is overtime (so the result of the formula
below may or may not be accurate). But its not like that
in all states.