[Libreoffice-bugs] [Bug 124209] AM/PM time notation in CALC
https://bugs.documentfoundation.org/show_bug.cgi?id=124209
--- Comment #7 from gmarco ---
and HELP is still wrong:
=TIMEVALUE("4PM") returns 0.67. When formatting in time format HH:MM:SS, you
then get 16:00:00.
It gets ERR:502, it has to be "4P.M." or "4p.m."
--
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 124209] AM/PM time notation in CALC
https://bugs.documentfoundation.org/show_bug.cgi?id=124209 --- Comment #6 from gmarco --- well, it will be NOTABUG, but really it is NOTALOGIC! The sequence will be: 11:59:59 p.m. 12:00:00 a.m. ... 12:00:59 a.m. 01:00:00 a.m. ... 11:59:59 a.m. 12:00:00 p.m. is it not wonderful ? -- 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 124209] AM/PM time notation in CALC
https://bugs.documentfoundation.org/show_bug.cgi?id=124209 Eike Rathke changed: What|Removed |Added Status|RESOLVED|CLOSED -- 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 124209] AM/PM time notation in CALC
https://bugs.documentfoundation.org/show_bug.cgi?id=124209 Eike Rathke changed: What|Removed |Added Status|UNCONFIRMED |RESOLVED Resolution|--- |NOTABUG --- Comment #5 from Eike Rathke --- I repeat: Times between 00:00:00 and 00:59:59 in AM/PM notation *are* 12:..:.. AM, there is no 00:..:.. AM. -- 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 124209] AM/PM time notation in CALC
https://bugs.documentfoundation.org/show_bug.cgi?id=124209 --- Comment #4 from gmarco --- Well, I said "if =ORARIO(23;59;59) gets 11:59:59 p.m. and =ORARIO(0;0;0) gets 12:00 a.m. when time will be 0:00:00?" and, I can add, looking at this sequence '=ORARIO(23;59;59) 11:59:59 p.m. '=ORARIO(0;0;0) 12:00:00 a.m. ? '=ORARIO(0;0;1) 12:00:01 a.m. ? '=ORARIO(1;0;0) 01:00:00 a.m. '=ORARIO(12;0;0) 12:00:00 p.m. if 1;0;0 is 01 a.m. why 0;0;0 is 12 a.m.? for me saying 24 means midnight and one second later is one second after midnight, not after twelve o'clock. -- 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 124209] AM/PM time notation in CALC
https://bugs.documentfoundation.org/show_bug.cgi?id=124209 --- Comment #3 from Eike Rathke --- I don't get what the actual problems are, except that "4PM" results in error because the format to be parsed has to match a locale's specified AM/PM symbol, which is "p.m." here, not "pm". Specifically the "(senseless)" comments don't make sense to me. Times between 00:00:00 and 00:59:59 in AM/PM notation *are* 12:..:.. AM, there is no 00:..:.. AM. The TIME() function (ORARIO()) does advance by the arguments given, so =TIME(23;119;59) is indeed 00:59:59 and =TIME(23;119;60) is 01:00:00 -- 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 124209] AM/PM time notation in CALC
https://bugs.documentfoundation.org/show_bug.cgi?id=124209 Roman Kuznetsov <79045_79...@mail.ru> changed: What|Removed |Added CC||er...@redhat.com Blocks||107575 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=107575 [Bug 107575] [META] Number format bugs and enhancements -- 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 124209] AM/PM time notation in CALC
https://bugs.documentfoundation.org/show_bug.cgi?id=124209
--- Comment #2 from gmarco ---
forgotten example
## as exemplified it gets ERR:502, it has to be "4P.M." or "4p.m."
Err:502← =ORARIO.VALORE("4PM")
16:00:00 ← =ORARIO.VALORE("4P.M.")
16:00:00 ← =ORARIO.VALORE("4p.m.")
--
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 124209] AM/PM time notation in CALC
https://bugs.documentfoundation.org/show_bug.cgi?id=124209 --- Comment #1 from gmarco --- look at this too: format: HH.MM.SS HH.MM.SS AM/PM =ORARIO(23;59;59) 23:59:59 11:59:59 p.m. =ORARIO(24;59;59) 00:59:59 12:59:59 a.m. (senseless) =ORARIO(24;59;60) 01:00:00 01:00:00 a.m. OK but look at SS=60 =ORARIO(23;59;60) 00:00:00 12:00:00 a.m. (senseless) =ORARIO(23;60;60) 00:01:00 12:01:00 a.m." =ORARIO(23;60;61) 00:01:01 12:01:01 a.m." =ORARIO(23;119;59) 00:59:59 12:59:59 a.m." and look at MM=119 =ORARIO(23;119;60) 01:00:00 01:00:00 a.m. OK but look at MM=119 and SS=60 -- 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
