https://bugs.documentfoundation.org/show_bug.cgi?id=136615
--- Comment #26 from SheetJS <d...@sheetjs.com> --- > 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 If the stated interpretation is correct, the inconsistency is that "hh:mm:ss" and "hh:mm:ss.000" currently round. The example was discussed in issue https://bugs.documentfoundation.org/show_bug.cgi?id=150049 : ``` TEXT(0.00069, "hh:mm:ss.000") ## 00:00:59.616 TEXT(0.00069, "hh:mm:ss.00") ## 00:00:59.62 rounding? ``` "Clock formats that don't round" suggests that the results should be: "hh:mm:ss" => 00:00:59 "hh:mm:ss.0" => 00:00:59.6 "hh:mm:ss.00" => 00:00:59.61 "hh:mm:ss.000" => 00:00:59.616 -- You are receiving this mail because: You are the assignee for the bug.