adding times

  • Thread starter Thread starter Potvaliant
  • Start date Start date
P

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?
 
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.
 
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.
 
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?
 
Back
Top