[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