IF THEN formula

C

carrera

Hello All

This is my formula:

=((AE24/60/24)-AM24) it is formated for time hh:mm

If the product of this is less than 0, I need it to read 0.

What do I need to add to my formula to make this so?
 
C

carrera

Great - but one more thing (i forgot)
the formula above this one is
=AE23/60/24

Once I get the formula below to the zero or below mark, how can I get the
above to start subtracting the time from above.

If it helps - I'm subtracting lunch time (from 30 min to an hour or more)
first from their overtime, then going into their straight time.

Let me know and thanks
 
Top