Windows XP Adding hours, minutes and seconds

[rrangassamy]

Hi Guys I need some help, I have a large number of cells with format 00:00:00 I need to sum them, in other words I need to get the total of an entire column with time in that format, how can I do it.

IE
01:25:33
02:22:42
00:48:55
01:33:32

xx:xx????

Thanks!

 

[nivrip]

Check out Excel Help > Date and Time Formulas > Add Times

 

[Chuck D]

In Final cell or for column change format to Format /Number / Custom / [h];mm;ss
this will give you a total sum of all times ie: if you add to your example 10:03:45 and 12:00:00
the result will be total time ie 28:14:27 as opposed to 04:14:27 which you will get in the Time format

Have fun...

 

[rrangassamy]

Now that's what I call an answer!!

Thank you Chuck!

Robert