Home » Category » Microsoft Excel

Microsoft Excel: adding times

205| Fri, 23 May 2008 20:08:00 GMT| anonymous| Comments (3)
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?

Keywords & Tags: adding, times, microsoft, excel

URL: http://www.developertags.com/microsoft-excel/15162/
 
«« Prev - Next »» 3 helpful answers below.
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.

>--Original Message--
>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 | Fri, 23 May 2008 20:10:00 GMT |

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.

potvaliant | Fri, 23 May 2008 20:11:00 GMT |

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?
>--Original Message--
>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 | Fri, 23 May 2008 20:12:00 GMT |

Microsoft Excel Hot Answers

Microsoft Excel New questions

Microsoft Excel Related Categories