[Libreoffice-bugs] [Bug 124209] AM/PM time notation in CALC

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Mon Mar 25 15:54:42 UTC 2019


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

--- Comment #4 from gmarco <gmmellina at inwind.it> ---
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190325/984be6de/attachment.html>


More information about the Libreoffice-bugs mailing list