You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2017/06/14 18:35:51 UTC
[Issue 127442] New: Wrong time-frame calculation
https://bz.apache.org/ooo/show_bug.cgi?id=127442
Issue ID: 127442
Issue Type: DEFECT
Summary: Wrong time-frame calculation
Product: Calc
Version: 4.1.2
Hardware: PC
OS: Windows 10
Status: UNCONFIRMED
Severity: Critical
Priority: P5 (lowest)
Component: programming
Assignee: issues@openoffice.apache.org
Reporter: bar.bugzilla@q4t.us
Target Milestone: ---
Created attachment 86147
--> https://bz.apache.org/ooo/attachment.cgi?id=86147&action=edit
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
--
You are receiving this mail because:
You are the assignee for the issue.