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

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 124209
           Summary: AM/PM time notation in CALC
           Product: LibreOffice
           Version: 6.2.0.3 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: gmmellina at inwind.it

Following on Bug 105226 (2017-01-09 / 2018-01-27) I propose again some
questions about AM/PM time notation and other problems about help (IT)
examples.

ORARIO
(
https://help.libreoffice.org/6.2/it/text/scalc/01/func_time.html?DbPAR=CALC#bm_id3154073
)
Esempio
=ORARIO(0;0;0) restituisce 00:00:00
=ORARIO(4;20;4) restituisce 04:20:04

## it depends by cell-format and can be:
00:00
00:00:00
0.00
0.00.00
00:00,00
00:00:00,00
12:00 a.m.
        but this is senseless: 12 o'clock comes after 11:59 and before 12:01
(*)
12:00:00 a.m.     but this is ... idem
12.00 a.m.        but this is ... idem
12.00.00 a.m.     but this is ... idem

(*) 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?


ORARIO.VALORE
(
https://help.libreoffice.org/6.2/it/text/scalc/01/func_timevalue.html?DbPAR=CALC#bm_id3146755
)
Esempio
=ORARIO.VALORE("4PM") restituisce 0,67. Nel formato orario HH:MM:SS viene
visualizzato 16:00:00.

## as exemplified 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190319/61ecc225/attachment-0001.html>