https://bugs.documentfoundation.org/show_bug.cgi?id=106240
--- Comment #4 from Jerzy MoruĊ <yes...@yestok.pl> ---
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.
--
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
