https://bugs.documentfoundation.org/show_bug.cgi?id=104253
Eike Rathke <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
Resolution|--- |NOTABUG
--- Comment #3 from Eike Rathke <[email protected]> ---
A2 is greater than B2 (2016-10-28 14:05:00 and 2016-10-28 00:00:00) so =B2-A2
gives a negative value which you formatted as wall clock time instead of
duration. Using format code [HH]:MM:SS instead on C2 will show -14:05:00 and
for E2 (=C2*D2) -16:11:45
--
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
