<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><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="https://bugs.documentfoundation.org/show_bug.cgi?id=127170#c15">Comment # 15</a>
on <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="https://bugs.documentfoundation.org/show_bug.cgi?id=127170">bug 127170</a>
from <span class="vcard"><a class="email" href="mailto:albrecht.mueller@astrail.de" title="Albrecht Müller <albrecht.mueller@astrail.de>"> <span class="fn">Albrecht Müller</span></a>
</span></b>
<pre>(In reply to Jaromir / <a href="mailto:jarko@sortsk.pl">jarko@sortsk.pl</a> from <a href="show_bug.cgi?id=127170#c14">comment #14</a>)
<span class="quote">> In my opinion -45 minutes should be always treated as "-00:45" (that is
> [HH]:MM). </span >
How would you then represent something like "1899-12-29 23:15:00" or - a more
common case - like "2020-04-23 19:33:05"?
<span class="quote">> Involving reference points makes a mess: you always have to
> remember your "startpoint".</span >
This was never a problem for me: Not I have to remember the reference point but
the spreadsheet program has to know where it is. But I understand that this may
cause trouble as there are different conventions. How would you define points
in time without some reference point?
<span class="quote">> Yes, it is possible to maintain double (float/integer) operations for each
> time/date value. But for the price of unnecessary overloading.</span >
I don't understand this argument: Depending on the context time may be seen as
continuous process or a sequence of countable ticks. So both a float and an
integer representation may be adequate. In the context of date and time
calculations the error recovery mechanism is not very complicated.
<span class="quote">> Let's use it only in very situations: when backward compatibility is required.</span >
I consider this a pretty important use case. If written on paper you can read
calculations that are hundreds of years old. How long should it be possible to
access contents of spreadsheets?</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>