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

How long do you think until flying cars or taxis are common?

Discuss in The Lounge

Poll History