<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:erack@redhat.com" title="Eike Rathke <erack@redhat.com>"> <span class="fn">Eike Rathke</span></a>
</span> changed
<a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED DUPLICATE - FORMATTING - Wrong date substraction in cell's operation"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=132083">bug 132083</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>REOPENED
</td>
<td>RESOLVED
</td>
</tr>
<tr>
<td style="text-align:right;">Resolution</td>
<td>---
</td>
<td>DUPLICATE
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED DUPLICATE - FORMATTING - Wrong date substraction in cell's operation"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=132083#c17">Comment # 17</a>
on <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED DUPLICATE - FORMATTING - Wrong date substraction in cell's operation"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=132083">bug 132083</a>
from <span class="vcard"><a class="email" href="mailto:erack@redhat.com" title="Eike Rathke <erack@redhat.com>"> <span class="fn">Eike Rathke</span></a>
</span></b>
<pre>Once and for all:
HH:MM is a *CLOCK* time format, your clock does not display 13:00 if the time
is 12:59 and 31 seconds, or 00:00 for a time of 23:59 and 31 seconds. Certainly
you do not expect to see 2020-04-16 00:00 or even worse 2020-04-15 00:00
instead of 2020-04-15 23:59
Furthermore, HH:MM is restricted to values between 00:00 and 23:59; if you
subtracted date+time values that span 24 hours or more you'd get wrong display
values with that.
[HH]:MM is a *DURATION* time format that handles all that, does proper rounding
and can display negative times as well.
However, I agree that the documentation / help could be more verbose on that
and explain better. For this it's a duplicate of <a class="bz_bug_link
bz_status_NEW "
title="NEW - Clarify clock time (HH:MM, MM:SS, ...) and duration time ([HH]:MM, [MM]:SS, ...) formatting in help; (ignore the MM month vs minute discussion)"
href="show_bug.cgi?id=127170">bug 127170</a>.
*** This bug has been marked as a duplicate of <a class="bz_bug_link
bz_status_NEW "
title="NEW - Clarify clock time (HH:MM, MM:SS, ...) and duration time ([HH]:MM, [MM]:SS, ...) formatting in help; (ignore the MM month vs minute discussion)"
href="show_bug.cgi?id=127170">bug 127170</a> ***</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>