Help me valuating time

[Gonçalo Ricardo]

I have this problem:
I need to see if for exemple 17:00-16:00-1:00 = 0
Doing the direct formula the result is 0 like i want, but trying th
logical way, the result is false.
for exemple:
if B1 -> 17:00 B2 -> 16:00 B3->1:00

or(b1-b2-b3=0)

the answord should be true but the result i recive is *false[/U*].


i know that the time expression is a fraction of time, so I transfor
the cell whit the expression 17:00 into 0,708333333 and make the sam
with the oders, the result of the formula wasn't 0 like i expected.
How can i resolve this problem.

Please help me!!

 

[Bob Phillips]

It's a problem with FPA, there is a limit to its accuracy.

Don't know if this is acceptable but try

=(B1*1440-B2*1440-B3*1440)=0

 

[Tom Ogilvy]

one second would be: .0000115741

so
if abs(b1-b2-b3) < .0000115741 then

or maybe allow 30 seconds of variation

if abs(b1-b2-b3) < .0000115741*30 then