Bug 97031 - Calc gives the wrong answers when doing arithmetic with differences of times
Summary: Calc gives the wrong answers when doing arithmetic with differences of times
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.0.4.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-01-10 23:33 UTC by Reese4302
Modified: 2016-01-11 00:30 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
It shows that averages and a sum of differences of times are wrong in Calc (51.43 KB, application/vnd.oasis.opendocument.spreadsheet)
2016-01-10 23:33 UTC, Reese4302 		Details
Sample file modified with a way to solve. (23.33 KB, application/x-vnd.oasis.opendocument.spreadsheet)
2016-01-11 00:30 UTC, m_a_riosv 		Details
View All 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 Reese4302 2016-01-10 23:33:01 UTC 
Created attachment 121841 [details]
It shows that averages and a sum of differences of times are wrong in Calc

Differences of times are correct in Calc.  Sums and averages of time differences are wrong.

[1]  See the attachment.
Comment 1 Joel Madero 2016-01-11 00:02:35 UTC 
This isn't a bug - please go to ask.libreoffice.org or the user mailing list to get advice on how to properly use times in calculations.

Moving to NOTABUG. Thanks
Comment 2 m_a_riosv 2016-01-11 00:30:23 UTC 
Created attachment 121842 [details]
Sample file modified with a way to solve.

I think not such issue.

Please take a look:
https://help.libreoffice.org/5.0/Calc/Date_and_Time_Functions
https://help.libreoffice.org/index.php?title=5.0/Common/Numbers_Format&Language=en-US&System=WIN&Version=5.0#bm_id3153312

In your sample time#2 have not taking in account if they are before or after time#1.

time format shows always positives values, so for negatives it shows the complementary.

I think in attached file you can find what is happen an a way to solve it, using right values for the average.