LibreOffice SUM time period in format HH:MM:SS
Solution 1
You have the wrong format. HH wraps around every 24 hours. Try using [HH] instead of HH, then you get the total number of hours.
Solution 2
The problem was on the way the data were inserted. Even if cells were formatted as Date, analysing them more in detail I found the values were preceded by an ' (apostrophe). Thus means LibreOffice were seeing them as text string and not a period of time. Deleting the apostrophe solved the issue.
Gianluca
Sr Data Analyst in an ad tech firm. MSc in Economics and Finance. Passionate about Statistics and Machine Learning.
Updated on July 30, 2022Comments
-
Gianluca almost 2 years
I want to obtain the sum of several cells containing a period of time in the format HH:MM:SS. In LibreOffice Calc 4.0.3.3, I've copy-pasted the periods of time in the range G14:G21, and formatted the cells as Time HH:MM:SS. I formatted in the same way the cell G22, and inserted in it the following SUM function:
=SUM(G14:G21)
Instead of the expected result, the function returns me this solution 00:00:00. Could you explain me where am I wrong?