https://bugs.documentfoundation.org/show_bug.cgi?id=136615
--- Comment #24 from Eike Rathke <er...@redhat.com> --- (In reply to SheetJS from comment #22) > LibreOffice, by contrast, appears to be inconsistent. Testing the same > examples: > > =TEXT(0.999999930555556,"hh:mm:ss") ## 23:59:59 (truncate) > =TEXT(0.999999930555556,"[hh]:mm:ss") ## 24:00:00 (round to sec) > =TEXT(0.999999930555556,"hh:mm:ss.000") ## 23:59:59.994 (round to msec) Au contraire, that's very consistent. "[hh]:mm:ss" is a duration format that rounds, "hh:mm:ss" and "hh:mm:ss.000" are clock formats that don't round to sec/min/hour. Your clock doesn't display 00:00:00 if it's 23:59:59.9 However, what is still inconsistent is that =TEXT(44858.9999999306;"yyyy-mm-dd hh:mm:ss") results in 2022-10-25 00:00:00 instead of 2022-10-24 23:59:59 whereas =TEXT(44858.9999999306;"yyyy-mm-dd hh:mm:ss.000") correctly results in 2022-10-24 23:59:59.994 -- You are receiving this mail because: You are the assignee for the bug.