Bug 144683 - Calculation error for hourly format in Calc - erreur de calcul pour format horaire dans calc
Summary: Calculation error for hourly format in Calc - erreur de calcul pour format ho...
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.1.6.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-09-23 17:22 UTC by serge.boucher@univ-tln.fr
Modified: 2021-09-24 11:27 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
A example of false result after a time sum in HH:MM format (10.41 KB, application/vnd.oasis.opendocument.spreadsheet)
2021-09-23 17:25 UTC, serge.boucher@univ-tln.fr 		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 serge.boucher@univ-tln.fr 2021-09-23 17:22:45 UTC 
Description:
When calculating a sum of cells in HH: mm format, the result is incorrect 
quand on calcule une somme de cellules au format HH:MM , le résultat est incorrect

Steps to Reproduce:
1.Enter time in HH:MM format in multiple cells
2.Request the sum in another cell, always in HH:MM format
3.The result is false 

Actual Results:
false result

Expected Results:
give the good result


Reproducible: Always


User Profile Reset: No



Additional Info:
But it's good with [HH]:MM format
Comment 1 serge.boucher@univ-tln.fr 2021-09-23 17:25:00 UTC 
Created attachment 175225 [details]
A example of false result after a time sum in HH:MM format
Comment 2 m_a_riosv 2021-09-23 21:08:49 UTC 
You need to change the format to show the total of hours, not the hour of the day for the sum
format: [HH]:mm

In https://help.libreoffice.org/latest/en-US/text/shared/01/05020301.html?&DbPAR=CALC&System=WIN search for Time Formats
Comment 3 serge.boucher@univ-tln.fr 2021-09-24 09:15:18 UTC 
Hi,

Thank you for your response and sorry ... It was not a bug.

Bye
Comment 4 m_a_riosv 2021-09-24 11:27:01 UTC 
When you have doubts, it's better to go first to https://ask.libreoffice.org/, and ask in the forum.