Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

I am using format-value-time to have cells where I input minutes/seconds, like 13:45 for 13 minutes & 45 seconds. If I have several of these cells, how can I add them all up?

Example:

Cell1: 00.13.45

Cell2: 00.05.12

Cell3: Should display cell1 + cell2 in the format 00.18.57

share|improve this question

2 Answers 2

You should be able to do that quite easy with a summation (do use colons (:) in the notation):

  • A1=00:13:45
  • A2=00:05:12

Then use SUM formula:

  • SUM(A1:A2)

The result will be: 00:18:57

UPDATE 18-01-2013
See example file I´ve created: Google Spreadsheets: Counting minutes/seconds

If you use Neo's formula, to get rid of the points, in combination with an ARRAYFORMULA you will get the result as well:

=ARRAYFORMULA(SUM(TIME(LEFT(B2:B3,2), MID(B2:B3,4,2), RIGHT(B2:B3,2))))

See example file (+1 for Neo)

share|improve this answer
    
It could have problem if the summation of hour is more than 24. The cells hide date value. –  neo Jan 17 '13 at 13:57
    
@neo: it doesn't affect hours beyond 24 hours, see example file. -1 for you. –  Jacob Jan Tuinstra Jan 17 '13 at 14:08
    
haha. I set the column format to time but it couldn't beyond 24 hours. +1 for you. –  neo Jan 17 '13 at 14:13
    
"do use double point in the notation" I've always heard this called a colon. Is "double point" correct for time notation? –  spex Oct 11 '13 at 13:17
    
@spex I guess you're right !! I have an excuse though: I'm Dutch....Why don't you edit my answer and make the correction. –  Jacob Jan Tuinstra Oct 11 '13 at 13:22

Below should help,

=TIME(LEFT(A1,2), MID(A1,4,2), RIGHT(A1,2))+TIME(LEFT(A2,2), MID(A2,4,2), RIGHT(A2,2))
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.