Using an IF formula in cells formatted as date & time

Microsoft Excel 2010 (full product)
February 21, 2013 at 05:46:56
Specs: Windows 7
I am trying to create a planner where one can see by means of conditional formatting if the current time is before or later than a fixed time. For some reason the formala is only seeing the date change but not the time. What is the best way to do this.

=IF(C2>$A$2,"OK","nok") both cell C@ and A@ are formatted date & time


See More: Using an IF formula in cells formatted as date & time

Report •


#1
February 21, 2013 at 12:56:20
Your formula should work.

How is the Data ( Date & Time) being entered into the cells?

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question