https://bugs.documentfoundation.org/show_bug.cgi?id=136050
Eike Rathke <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Resolution|--- |NOTABUG
Status|UNCONFIRMED |RESOLVED
--- Comment #2 from Eike Rathke <[email protected]> ---
A single MM format code is month of year, not minutes, and displays the
underlying cell value accordingly. This is not a bug and will not be changed.
There is no time type or date type cell. A date or time or date+time is just a
floating point number, days since null date, where 0.5 is 12 hours, the time
00:19 with 0 days since null date formatted as date happens to be 1899-12-31 so
the result for MM is 12.
You can use the format code [MM] to format a duration in minutes only.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
