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@lists.freedesktop.org
Reporter: gmmell...@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.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs