https://bugs.documentfoundation.org/show_bug.cgi?id=148126
--- Comment #22 from SheetJS <[email protected]> --- The "Test File" was modified when viewing the file in newer versions of Numbers. The "Original Test File" is the original one from 2022. LibreOffice 7.2.5.2 (mac aarch64) shows a blank cell in B10. The current version shows 2021:00:00 in the formula bar, a reasonable value (2021 hours -> 12 weeks 5 hours), so there was a noticeable improvement. --- Even if there is no built-in support for absolute days or weeks, it might make sense to mark Numbers duration cells with one of the relevant time formats. The fifth "Time" format as shown in the "Duration Number Format" attachment is `[HH]:MM:SS` and the seventh "Time" format is `[HH]:MM:SS.00` -- You are receiving this mail because: You are the assignee for the bug.
