Bug 144683

Summary: Calculation error for hourly format in Calc - erreur de calcul pour format horaire dans calc
Product: LibreOffice Reporter: serge.boucher <serge.boucher>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED NOTABUG    
Severity: normal CC: miguelangelrv
Priority: medium    
Version: 7.1.6.2 release   
Hardware: x86-64 (AMD64)   
OS: Windows (All)   
Whiteboard:
Crash report or crash signature: Regression By:
Attachments: A example of false result after a time sum in HH:MM format

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.