https://bugs.documentfoundation.org/show_bug.cgi?id=119533
Eike Rathke <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |[email protected]
--- Comment #2 from Eike Rathke <[email protected]> ---
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
