Bug 123900 - Substraction of two times leads two a wrong duration
Summary: Substraction of two times leads two a wrong duration
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-06 13:25 UTC by Gordon
Modified: 2019-03-06 22:59 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Gordon 2019-03-06 13:25:10 UTC 
Description:
The formula was like "=D12-C12". D12 was the endtime of 8:25 and C12 was the starttime of 7:50. The result was 34 minutes, while the correct result clearly must be 35 minutes.

Steps to Reproduce:
1.Open Spreadsheet
2.Type Formula "=D12-C12"
3.Enter Time 7:50 in C12
4.Enter Time 8:25 in D12

Actual Results:
00:34

Expected Results:
00:35


Reproducible: Sometimes


User Profile Reset: No


OpenGL enabled: Yes

Additional Info:
Version: 6.2.0.3 (x64)
Build-ID: 98c6a8a1c6c7b144ce3cc729e34964b47ce25d62
CPU-Threads: 8; BS: Windows 10.0; UI-Render: GL; VCL: win; 
Gebietsschema: de-DE (de_DE); UI-Sprache: de-DE
Calc: threaded
Comment 1 raal 2019-03-06 14:55:38 UTC 
No repro Version: 6.3.0.0.alpha0+
Build ID: 65438bcda46bab4f2fe6fb555f44aace45e11e5e
CPU threads: 4; OS: Windows 6.1; UI render: default; VCL: win; 


Seems to be fixed with dev version. Please could you test it with dev version?  You can download it here: http://dev-builds.libreoffice.org/daily/master/
Thank you
Comment 2 Aron Budea 2019-03-06 22:59:42 UTC 
This looks like bug 122991, please test again with version 6.2.1.2.

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