SUM time period in format HH:MM:SS

[Gianluca1]

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?

[mahfiaz]

Your original fields do not contain time but some text (numbers can be text as well) which looks like time to you. Try to type 0:10 and 0:12 followed by an enter and sum these to see how it works.

There is a very similar question: Sorting of numbers with slashes - #9 by ROSt53 (see my answer two comments up)