Regular Hours and OT Hours

L

Laurie

This worked perfectly - Thanks for the information. I am also working on the
same timesheet and I want to summarize Reg Hours and Overtime hours. I need
a formula that will separte reg and overtime hours. For example I have two
cells (2 diff. weeks) that have hours worked for the week. One cell could
have 42 hours in it or it could have 36 hours in it. What I need is a
formula that will pull out anything under 40 and put it in (summary-combined
2 weeks) regular and anything over 40 and put it in (summary-combined 2
weeks) OT.

If more information is needed let me know - I'm not that great at explaining.

Thanks,
Laurie
 
B

Bob Phillips

=MIN(40,cell_with_hours_in)

gives the regular hours

=MAX(0,cell_with_hours_in-40)
 
Top