LibreOffice SUM time period in format HH:MM:SS

calclibreofficesumtime

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?

Best Solution

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.