Regular hours
=MIN(SUM(C1:C5),40)

Overtime hours
=MAX(SUM(C1:C5)-40,0)

Adjust to suit


"Sean" wrote:

I am trying to write a spreadsheet for tracking man-hours worked over a pay
period.

What I want to do is sum the fields for the first week, and if the total is
greater than 40, convert the remaider greater than 40 to a value in another
field. Also, a pay period is 2 weeks, so I want to apply the function to
each week seperately, but then sum the total regular hours and overtime hours
individually. The regular hours block for a given pay period should be no
more than 80, but the OT could be more. Also, because of some of the odd
shifts that our production personnel work, it is completely possible that an
individual can be earning overtime in less than 4 work days.

If anyone can help me with this, I would be most appreciative.

Thanks.

Sean