Bug 124047 - Calc: Wrong calculation of time differences
Summary: Calc: Wrong calculation of time differences
Status: RESOLVED DUPLICATE of bug 122991
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.2.0.3 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-03-13 10:11 UTC by enceladus
Modified: 2019-03-13 21:27 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Field D2 should display -00:45 (2.97 KB, image/png)
2019-03-13 10:13 UTC, enceladus
Details

Note You need to log in before you can comment on or make changes to this bug.
Description enceladus 2019-03-13 10:11:45 UTC
Description:
Having a field formatted as [HH]:MM the value of which has been calculated from two other fields formatted as HH:MM and one field formatted as [HH]:MM the result misses one minute if it is negative.

Steps to Reproduce:
1. Format Field A1 as [HH]:MM and set it to 08:00
2. Format Field A2 as HH:MM and set it to 08:15
3. Format Field B2 as HH:MM and set it to 15:30
4. Format Field C2 as [HH]:MM and set formula B2 - A2
5. Format Field D2 as [HH]:MM and set formala to C2 - A1

Actual Results:
The result in field D2 is 00:44

Expected Results:
The result in field D2 should be 00:45


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
If B2 is set to 16:30 the result is correct: 00:15 (as with all positive differences)

If you changes the [HH]:MM formattings to [HH]:MM:SS you will see that exactly one second is missing (result is 00:44:59 instead of expected 00:45:00).


About LibreOffice:
Version: 6.2.0.3 (x64)
Build-ID: 98c6a8a1c6c7b144ce3cc729e34964b47ce25d62
CPU-Threads: 4; BS: Windows 6.3; UI-Render: GL; VCL: win; 
Gebietsschema: de-DE (de_DE); UI-Sprache: de-DE
Calc: threaded
Comment 1 enceladus 2019-03-13 10:13:12 UTC
Created attachment 149929 [details]
Field D2 should display -00:45
Comment 2 enceladus 2019-03-13 10:15:02 UTC
Sorry, correction: Result is -00:44 and should be -00:45.
Comment 3 Xisco Faulí 2019-03-13 21:27:50 UTC
This is a duplicate of bug 122991. Please update to LibreOffice 6.2.1.2

*** This bug has been marked as a duplicate of bug 122991 ***