[Libreoffice-bugs] [Bug 127170] Clarify clock time (HH:MM, MM:SS, ...) and duration time ([HH]:MM, [MM]:SS, ...) formatting in help; (ignore the MM month vs minute discussion)

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #15 from Albrecht Müller <albrecht.mueller at astrail.de> ---
(In reply to Jaromir / jarko at sortsk.pl from comment #14)
> In my opinion -45 minutes should be always treated as "-00:45" (that is
> [HH]:MM). 
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"?

> Involving reference points makes a mess: you always have to
> remember your "startpoint".
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?

> Yes, it is possible to maintain double (float/integer) operations for each 
> time/date value. But for the price of unnecessary overloading.
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.

> Let's use it only in very situations: when backward compatibility is required.
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?

-- 
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/20200423/1bff99f0/attachment.htm>