https://bugs.documentfoundation.org/show_bug.cgi?id=123247
Bug ID: 123247
Summary: Sum of cells containing time values incorrect
Product: LibreOffice
Version: 6.2.0.3 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Using Time format [HH]:SS the sum of several cells containing time values is
incorrect (one minute below correct value).
Steps to Reproduce:
1. Create a few cells with Time format code [HH]:MM
2. In one cell, enter 0:35 (for 35 minutes), in another enter 1:05 (for 1 hour,
5 minutes) and in another enter 0:10 (for 10 minutes).
3. Sum total of cells above in a new cell and result is 1:49 (should be 1:50).
If sum looks OK (1:50), try Ctrl+Shift+F9 (which I do occasionally to update
input fields). Sum will then change to 1:49.
Actual Results:
Sum total of cells in example above gives 1:49 (for 1 hour, 49 minutes).
Expected Results:
Sum total of cells in example above should be 1:50 (for 1 hour, 50 minutes).
Reproducible: Always
User Profile Reset: Yes
OpenGL enabled: Yes
Additional Info:
--
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
