|
Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
| Summary: | Wrong time-frame calculation | ||||||
|---|---|---|---|---|---|---|---|
| Product: | Calc | Reporter: | bar.bugzilla | ||||
| Component: | programming | Assignee: | AOO issues mailing list <issues> | ||||
| Status: | UNCONFIRMED --- | QA Contact: | |||||
| Severity: | Critical | ||||||
| Priority: | P5 (lowest) | ||||||
| Version: | 4.1.2 | ||||||
| Target Milestone: | --- | ||||||
| Hardware: | PC | ||||||
| OS: | Windows 10 | ||||||
| Issue Type: | DEFECT | Latest Confirmation in: | --- | ||||
| Developer Difficulty: | --- | ||||||
| Attachments: |
|
||||||
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