Forum Discussion
Time calculation Error
Hi
Excel calculates the difference of 2 times wrong. It returns for 2:00h minus 2:00h -6,93889E17 (in G13).
The result in G19 is correct.
Thanks for your help.
This is a well known behavior of Excel which is due to the fact that many numbers cannot be converted to binairy numbers exactly. Hence some rounding errors may occur when subtracting (almost) identical numbers.