https://bugs.documentfoundation.org/show_bug.cgi?id=104253
--- Comment #4 from Ulrich Windl <[email protected]> ---
(In reply to Eike Rathke from comment #3)
> 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
I don't understand: The difference from "28.10.16 14:05" to "28.10.16 00:00" is
correctly displayed as "09:55:00"; what is not correct is the product of 1.2
times the duration ("09:55:00"). That works in D22. So effectively I see two
different results for the same formula. Something must be wrong! Why isn't the
default time format "[HH]:MM:SS" then?
--
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
