Help - Problem with date precission

[Matt]

Hi Guys,

now that my project is done I find another issue

I subtract 2 dates to get the duration in hours that has passed in
between:

AL2: 14:20:00 - 28 Sep 2005
AL5: 12:20:00 - 03 Oct 2005

This formula:

=$AL$2-$AL$5

yields this result:

118:00:00

which is correct.

Then I compare this value to a cell where I write 118:00:00.


=IF(AL$27>AM$27,1,0)

The problem is that the duration it calculated is different. Although
they both say 118:00:00 the calcualted is different which you can see
if you make it a number with 10 digits...

Is there any way to correct this? or force it to round dates?

Matt

 

[Matt]

I fixed it .. Sorry guys. I dont know why it is but usually I spent an
hour thinking into the problem and as soon i post a question the answer
pops up in fornt of my mental eye ..

Matt