https://bugs.documentfoundation.org/show_bug.cgi?id=145131
--- Comment #3 from Alex Sims <[email protected]> --- This issue is documented at https://wiki.documentfoundation.org/Faq/Calc/Accuracy In the example linked 2020-04-13 12:18:00 - 2020-04-13 12:08:00 is calculated into cell A3 and then "Cell A3 will show 00:09:59.999999 instead of expected 00:10:00.000000 if formatted using [HH]:MM:SS.000000 format string. This happens despite only whole numbers of hours and minutes were used, because internally, any time is a fraction of a day, 12:00 (noon) being represented as 0.5. The data in A1 is represented internally as 43934.5125, and in A2 as 43934.5055555555591126903891563 (which is not exact representation of the entered datetime, which would be 43934.505555555555555555...). Their subtraction results in 0.00694444443287037, a value slightly less than expected 0.00694444444444..., which is 10 minutes." So its a more fundamental problem with using a binary number to represent fractions of a day which can't be done exactly. -- You are receiving this mail because: You are the assignee for the bug.
