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

--
Regards,
Tom Ogilvy


"Gonçalo Ricardo" wrote in
message ...

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 the
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 *[u]false[/U*].


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

Please help me!!!


--
Gonçalo Ricardo
------------------------------------------------------------------------
Gonçalo Ricardo's Profile:
http://www.excelforum.com/member.php...o&userid=15302
View this thread: http://www.excelforum.com/showthread...hreadid=272737