Simply check to see if the hours worked is greater than 8. Something like:

=if(a2-a18,a2-a1-8,0)

Regards
Fred

"Matt" wrote in message
...
I have a time sheet that calculates start time and end time, neither of
which
could be constant times. That formula works fine.
I am looking to take the total hours for any given day and break them down
into regular hours (upto and including 8 hrs) and overtime pay (anything
over
8 hours).

The problem is that some days there might not be a full 8 hrs put in and
then the overtime hours result in an error.

The way I have it set up now is for OT to subtract 8hrs from the Total
hrs.
and then the Regular time subtracts the OT hours (or minutes) from the
Total
time.

How can I tell the OT formulat to do what I told it to but if the answer
is
a negative number to just enter '0'?

Or is there an easier solution???

Can anyone assist me????