https://bugs.documentfoundation.org/show_bug.cgi?id=136615
--- Comment #14 from Eike Rathke <[email protected]> --- (In reply to SheetJS from comment #12) > > The serial date-time 0.0000115... represents 00:00:01 > > 0.0000115 is 0.9936 / 86400, just shy of 1/86400 . Truncation would imply > "00:00:00" and rounding would imply "00:00:01". The reasonable conclusion > is that OOXML examples seems to imply rounding. > > Needless to say, LO is clashing with Excel: > =TEXT(0.0000115, "hh:mm:ss") > Excel and OOXML both yield 00:00:01 while LO yields 00:00:00 Yes, and if Excel is rounding 0.999999930555556 (=86399.994/86400) which is 23:59:59.994 to 00:00:00 that's obviously wrong. -- You are receiving this mail because: You are the assignee for the bug.
