Google Spreadsheets: Counting minutes/seconds

Question

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

Answer 1

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

Answer 2

You should be able to do that quite easy with a summation (do use double point 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)