Help me valuating time
 

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 *[u]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!!

--
Gonçalo Ricard
-----------------------------------------------------------------------
Gonçalo Ricardo's Profile: http://www.excelforum.com/member.php...fo&userid=1530
View this thread: http://www.excelforum.com/showthread.php?threadid=27273

Help me valuating time
 

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

--

HTH

RP

"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

Help me valuating time
 

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