ABS error

[DeCaelo]

=IF(ABS(F2-B2)<=TIMEVALUE("00:15"),"OK","NOT OK"))

F2 = 15/02/2011 23:30:00
B2 = 15/02/2011 23:45:00

The above formula keep showing "NOT OK" when the difference is only 00:15. What have I done wrong?

 

[shg]

Maybe a little floating-point error. Try

=IF(ABS(F2-B2)<=TIMEVALUE("00:15.01"), "OK", "NOT OK")

 

[DeCaelo]

Unfortunately not

I changed F2 to 15/02/2011 23:29:00, so a 00:16 difference, but this shows "OK".

 

[shg]

Sorry:

=IF(ABS(A$1-A2) <= TIMEVALUE("0:15:0.01"), "OK", "NOT OK")

      ---------A---------- --B--- ------------------------------C-------------------------------
  1   15 Feb 2011 12:00:00                                                                      
  2   15 Feb 2011 12:14:59 OK     B2: =IF(ABS(A$1-A2) <= TIMEVALUE("0:15:0.01"), "OK", "NOT OK")
  3   15 Feb 2011 12:15:00 OK                                                                   
  4   15 Feb 2011 12:15:01 NOT OK

 

[DeCaelo]

Perfect, thankyou