Ask Your Question
0

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 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?

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
0

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: http://ask.libreoffice.org/en/question/17406/sorting-of-numbers-with-slashes/?comment=17542#comment-17542 (see my answer two comments up)

edit flag offensive delete link more

Question Tools

Stats

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

Seen: 6,146 times

Last updated: May 22 '13