I'm trying to construct a formula that tells me if the time in a cell formatted as 0:00:00 (hours,minutes,seconds) is above or below a certain value. If above then yes, otherwise no. Have tried a lot of variations with not luck. Keeps sending back message about the formula. Microsoft 7 professional

Thanks

Keeps sending back message about the formula.Error messages are always good to know, tells us what's not happening.

Try this:

With your TIME in cell A1

and your New Value in B1

in cell C1 enter:=IF(B1>=A1,"YES","NO")

See how that works.

MIKE

Mike, Sorry for the late reply, but your suggestion worked.

Thanks

Bill

Ask Your Question

Weekly Poll