As you don't give any detail of your data, I'll guess!

Overtime: = MAX(0,Hoursworked-non_OT hours)

where non_OT hours is the standard working week (40 hours say).

If you need further help, supply details of your data/calculations.

"MsSnowy" wrote:

I am using an excel template to log my regular work hours, the hours I work
"overtime", and hours that I use to cover missed days from my "Overtime"
hours. What I have been trying to create, is a spreadsheet that will
automatically log the number of hours I work "overtime" from each spreadsheet
in this workbook (since each spreadsheet is one week's timecard) and subtract
any hours I use from those "overtime" hours to cover my missed days.

I have been subtracting and adding the hours up in a spreadsheet I created
previously, but I would like Excel to do this calculation for me, so I cannot
use hours I don't really have by accident.

Can anyone help?!