https://bugs.documentfoundation.org/show_bug.cgi?id=151460
Eike Rathke <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Hardware|Other |All Ever confirmed|0 |1 OS|macOS (All) |All Status|UNCONFIRMED |NEW --- Comment #2 from Eike Rathke <[email protected]> --- That is because date+time values are date serial numbers since the null-date as double floating point values. Let's assume A1: 2022-10-01 00:00:00.000 A2: 2022-10-01 01:00:00.000 with the underlying values (you can see when removing the date+time formatting) A1: 44835 A2: 44835.0416666667 Due to the binary floating point representation the difference A2-A1 is 0.041666666700621136 and not 0.0416666666666667, so a little less than required. -- You are receiving this mail because: You are the assignee for the bug.
