[Libreoffice-bugs] [Bug 119533] calculation of time differences wrong in LibreOffice 6.1

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Mon Aug 27 10:13:56 UTC 2018


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

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |erack at redhat.com

--- Comment #2 from Eike Rathke <erack at redhat.com> ---
So it seems we indeed need the extra rounding, but *sometimes* must not.
Problem here is that MINUTE(D2-C2) (30 minutes) yields 29 instead of 30.

@Jonathan:
Apart from that your calculation can be simplified to (for cell E2)
=(D2-C2)*24
which yields the correct result, and in cell F2
=(B2-A2)*24-E2
Note that dates and time is measured in days and fractions of day (1 day == 24
hours, 0.5==12h, ...)

-- 
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/20180827/3a70dcf2/attachment-0001.html>


More information about the Libreoffice-bugs mailing list