Time Reference problem

[dgavin]

Hi

K2 contains a changing time refernce that is inputed from another program linked to the spreadsheet.

In this case i stopped the spreadsheet at K2= 00:00:56

In K24 I have =IF(D33=0,IF(K24=0,K23,K24),K23) which captures the time when D33 is triggered.

I trying to use another trigger when K2 and K24 equal the same e.g. =IF(K2=K24,1,0)

But this doesn't seem to work, but when cells K2 and K24 are 00:00:56 I checked the formatting and if i changed both cells to General format they would be different

K2= 0.000648148

K24=0.000646019

Is this why K2 won't equal K24 when they are both 00:00:56 ?

Thanks

 

[rickbisselink]

You said it, they are not the same. If 00:00:56 is equal enough for you, why not try comparing rounded values?

 

[dgavin]

Perfect just what i need

Can you explain how i do this ?

 

[rickbisselink]

Try

=IF(ROUND(K2*86400,0)=ROUND(K24*86400,0),"equal","different")

(or your suitable version of it).


Rick