Assuming A4 is formatted as [h]:mm:ss

Try this:

=IF(A4=1,24,"no")


--
Biff
Microsoft Excel MVP


"myr" wrote in message
...
Can I use IF formula to ccmpare time? Ex =IF (A4=24:00:00, "24")