adding times

[Potvaliant]

I have a list of minutes and seconds eg, 5:33 (five
minutes, 33 secondes). I would like to add them together
but am not having any luck. Anyone know how to do this?

 

[Varun]

If you are just trying to add up hours and seconds, format
the cells as "Time" using just the e.g. 13:30 format, then
highlight the column's cells till the first free cell and
click on the Summation button. That will add up the hours.

 

[Potvaliant]

What I have been doing is formating in mm:ss and trying to
create a formula to add up the times in the column, but
all that seems to happen is that the first time in the
column is the only values that is recognized.

 

[Varun]

Format the cells as hh:mm:ss
Then ensure your times are entered with a 0 as the hh
e.g.
0:05:33
0:10:15
0:12:38
0:03:45

Then highlight all of them till the first available free
cell and click on the "E" (summation) button. It will give
the result as
0:32:11

Is this helpful?