<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - AM/PM time notation in CALC"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=124209">124209</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>AM/PM time notation in CALC
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.2.0.3 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>gmmellina@inwind.it
</td>
</tr></table>
<p>
<div>
<pre>Following on <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED FIXED - AM/PM locale for it_IT incorrect"
href="show_bug.cgi?id=105226">Bug 105226</a> (2017-01-09 / 2018-01-27) I propose again some
questions about AM/PM time notation and other problems about help (IT)
examples.
ORARIO
(
<a href="https://help.libreoffice.org/6.2/it/text/scalc/01/func_time.html?DbPAR=CALC#bm_id3154073">https://help.libreoffice.org/6.2/it/text/scalc/01/func_time.html?DbPAR=CALC#bm_id3154073</a>
)
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
(
<a href="https://help.libreoffice.org/6.2/it/text/scalc/01/func_timevalue.html?DbPAR=CALC#bm_id3146755">https://help.libreoffice.org/6.2/it/text/scalc/01/func_timevalue.html?DbPAR=CALC#bm_id3146755</a>
)
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."</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>