I don't understand!!
Posted by Ian Mac on February 01, 2002 3:32 AM
Can any 1 help.
I have the formula =if(B1,B1-A1,"")
looking at the Timevalues 17:00 (A1) and 17:00 (B1).
What it's doing is checking for variance (I'm using 1904 date system so it can handle negative timevalues)
The cell with the formula has Conditional formating, Cell Value Is - Greater Than 0 AND Cell Value Is - Less Than 0. both RED
The problem is that the cell value appears to be 0:00 but using F9 is -3.33066907387547E-16??? odd I thought, which makes the Conditions not work (well they are working really, just the formula isn't)
so in the next cell I simply type =B1-A1 and the answer is 0:00 or 0 (F9).
why would this happen????
One thing to add is that the first number (17:00) is the result of Vlookup and the other is just typed in.