IF Formula

[myr]

Can I use IF formula to ccmpare time? Ex =IF (A4>=24:00:00, "24")

 

[T. Valko]

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

Try this:

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