Issue 127442 - Wrong time-frame calculation
Summary: Wrong time-frame calculation
Status: UNCONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: 4.1.2
Hardware: PC Windows 10
: P5 (lowest) Critical (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-06-14 18:35 UTC by bar.bugzilla
Modified: 2017-06-14 18:35 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Calculate time difference for concrete test (8.87 KB, application/vnd.oasis.opendocument.spreadsheet)
2017-06-14 18:35 UTC, bar.bugzilla 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description bar.bugzilla 2017-06-14 18:35:51 UTC 
Created attachment 86147 [details]
Calculate time difference for concrete test

When I put-in 6/12/2017 12:15 am in one cell and put-in another cell 6/14/2017 4:16 pm and subtract the two the spreadsheet get 01 16:00:00 instead of 02 16:00:00.
06/12/17 12:15 AM
05/14/17 04:15 PM
01 16:00:00
=SUM(A2-A1)
DD HH:MM:SS