=IF(C5 <= TIME(40,0,0), "ok", "not")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Sunny" wrote in message
...
What is wrong with this formula =IF(C5 <= 40, "ok", "not")

c5 = 65:00 (65 hours 00 minutes) but it is still showing me ok