Hi!

Try something along these lines:

For straight time:

=MIN(SUM(Time_Range),80)

For OT (over 80):

=MAX(0,SUM(Time_Range)-80)

Biff

-----Original Message-----
I am trying to setup a payroll spreadsheet for a 2 week
period. I would like
once my total for an employee exceeds 80 hours to put the
additional hours
over 80 into a seperate overtime pay cell. Any
suggestions?
.