[Libreoffice-bugs] [Bug 132083] FORMATTING - Wrong date substraction in cell's operation

[bugzilla-daemon at bugs.documentfoundation.org]

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

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|REOPENED                    |RESOLVED
         Resolution|---                         |DUPLICATE

--- Comment #17 from Eike Rathke <erack at redhat.com> ---
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 bug 127170.

*** This bug has been marked as a duplicate of bug 127170 ***

-- 
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/20200415/edae2f9e/attachment.htm>