Solved Time for exercise above/below goal

March 11, 2013 at 07:43:38
Specs: Windows 7
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


See More: Time for exercise above/below goal

Report •

#1
March 11, 2013 at 13:17:09
✔ Best Answer
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

http://www.skeptic.com/


Report •

#2
April 12, 2013 at 16:13:12
Mike,

Sorry for the late reply, but your suggestion worked.

Thanks

Bill


Report •
Related Solutions


Ask Question