Thread: IF THEN formula
View Single Post
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
try:
=MAX(0,(AE24/60/24)-AM24)

--
Regards
Frank Kabel
Frankfurt, Germany
"carrera" schrieb im Newsbeitrag
...
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?