Time Calculation

[JC]

Try:

-----Original Message-----
Hi,
I have an employee time sheet already rounding to the

floor in increments and totaling daily and weekly.

I am trying to create an "if" formula but can't get it

to work properly... If cell p50 is less than or equal to
40.00 then=0, if cell p50 is greater than 40.00 then =
the difference of total hours (cell p50) - 40.00 into
cell p51.