[Libreoffice-bugs] [Bug 106240] Formatting time does not accept M or MM as minutes

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=106240

--- Comment #6 from Eike Rathke  ---
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).

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 106240] Formatting time does not accept M or MM as minutes

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=106240

Buovjaga  changed:

   What|Removed |Added

 CC||er...@redhat.com

--- Comment #5 from Buovjaga  ---
Eike: was I wrong to close this as NOTABUG?

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 106240] Formatting time does not accept M or MM as minutes

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=106240

--- Comment #4 from Jerzy Moruś  ---
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; .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 .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.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 106240] Formatting time does not accept M or MM as minutes

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=106240

Buovjaga  changed:

   What|Removed |Added

 Status|UNCONFIRMED |RESOLVED
 CC||todven...@suomi24.fi
 Resolution|--- |NOTABUG
Summary|Formatting  |Formatting time does not
   ||accept M or MM as minutes

--- Comment #3 from Buovjaga  ---
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.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs