hi,

the result of the formula is 0.0347222222222223
and the value of 0:50 in standard is 0.0347222222222222
because the data is converted to hexadecimal, the subtraction is made €‹€‹, and data are converted into decimal data.


--
isabelle

Le 2011-05-10 16:18, wabbleknee a écrit :
I am stumped on this one, so simple yet....

a1=9:00
b1=9:30
c1= the time difference with the formula =B1-A1 (results =0:30)
d1=0:30 (used as a reference or goal)
e1 formula =IF(c1=D1,"Yes","No") In this case the answer is YES

Now the hard part, if I change the cells to:
b1=9:50, c1 showes 0:50
D1=0:50
e1 is now = NO it should be YES

I tried test values of 0:49 and 0:51 by changing b1 d1 they work and say YES, only 0:50 minutes errors????

TX MIke