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