https://bugs.documentfoundation.org/show_bug.cgi?id=148126
--- Comment #13 from SheetJS <[email protected]> --- As mentioned in https://bugs.documentfoundation.org/show_bug.cgi?id=148126#c2 and verified now against LO 26.8.0.3, the underlying value in LibreOffice (84.208333...) is reasonable since 12 weeks + 5 hours is `12*7 + 5/24 ~ 84.20833333333333` To confirm, open the file in LibreOffice and set cell C10 to the formula `=TEXT(B10,"General")` --- Numbers doesn't expose a format string like Excel. There is a special UI which allows you to select which fields to display. See "Equivalent Custom Number Format for cell B10" screenshot. Like how ODS/FODS uses an XML representation, there's an internal binary representation of Numbers cell formats. There is a special cell type for "Duration" that is distinct from "Datetime". https://git.libreoffice.org/libetonyek/+/refs/heads/master/src/lib/IWAParser.cpp#2856 code reference. --- NOTE: Marking duration cells with a default duration format like `[HH]:MM:SS` would be a big improvement over current behavior. -- You are receiving this mail because: You are the assignee for the bug.
