Created attachment 113915 [details] Example of the issue Hello, in the file I attached, the cells A1 and A2 contain two dates with 1 second of difference In the cell A3, I substract A2 to A1, I multiplied the difference by 24*3600 to get the result in second and I convert the it into a number. The result is not exactly 1 but 1.0000000xxx where xxx is something different of 0. It should be exactly one.
This is not a bug per say, it's a limitation of floats. Closing as NOTABUG - please do not reopen. If you want further information you can email the dev list and request someone to explain the issue (it's quite technical but it's a computer limitation not a bug that is resolvable). Thanks for your understanding.