There is a problem with the code formatting for time. Format in the form HH: MM: SS shows the time represented by the variable. You can use the code H or HH for presenting exclusively hour, S or SS to represent exclusively seconds. You can not use the code M and MM for the presentation minutes because it is regarded as a code representing months. Using the code [MM] is interpreted correctly and shows the total time in minutes.
Hello Jerzy, Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided. (Please note that the attachment will be public, remove any sensitive information before attaching it. See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.)
Created attachment 131557 [details] Example of formatting time
I don't understand why this is a problem. I am sure there is some interoperability/compatibility reason behind this. https://help.libreoffice.org/Common/Number_Format_Codes Closing as not a bug.
Contrary to what you write, it is a problem. The idea of formatting cells containing the date and time for the possibility to show only one component of the date or time. Just then enter the code of the item. For example, HH for hours for the day DD, YY for the year. M code is assigned to the month - when it comes to the date and the minute - when it comes to time. In this situation, you use it when you format is ambiguous and Calc always interprets it as a month. Example. I gained some measurements recorded data in the system; YYYY.MM.DD HH:MM:SS. I want to show them providing minute of the first to the last measurement. The first and last measurement Formatting YYYY.MM.DD HH:MM and all intermediate as MM. I can not do because Calc interprets the code as a month instead of minutes. To reach your goal must use the function MINUTE(arg). In Finland, this problem can not be because the code for the month is K.
Eike: was I wrong to close this as NOTABUG?
Using M or MM standalone is formatting month, same as in Excel. Use [M] or [MM] if you want minutes duration (which even displays values >59).