Ask Your Question

SUM time period in format HH:MM:SS [closed]

asked 2013-05-22 23:17:46 +0100

Gianluca gravatar image

I want to obtain the sum of several cells containing a period of time in the format HH:MM:SS. In LibreOffice Calc, 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:


Instead of the expected result, the function returns me this solution 00:00:00. Could you explain me where am I wrong?

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-01 19:47:02.825622

1 Answer

Sort by » oldest newest most voted

answered 2013-05-22 23:29:27 +0100

mahfiaz gravatar image

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: (see my answer two comments up)

edit flag offensive delete link more

Question Tools


Asked: 2013-05-22 23:17:46 +0100

Seen: 6,146 times

Last updated: May 22 '13