Maybe this

=MAX(M11-(M14+M15)-40,0)

Mike

"Melissa" wrote:

I have total hours in cell M11. In cell M13 I have a formula calculating
overtime hours: =IF(M1140,M11-40,0). What I'm trying to do is cause the
cell with this formula to calculate the hours ONLY if the overtime hours are
over 40 AND outside of PTO and/or Holiday hours.

Here's an example:

total hours (cell M12)= 42.33
overtime hours (cell M13)= 2.33
PTO hours (cell M14) = 8.00
Holiday hours (cell M15) = 8.00

Total work hours INCLUDES pto and holiday hours, so overtime hours should
NOT be showing 2.33, but rather zero.

How do I create/modify my current formula (above) to calculate this properly?

Thanks!

Melissa