Windows XP Adding hours, minutes and seconds

R

rrangassamy

Joined
Dec 24, 2009
Messages
2
Reaction score
0
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!
 
Check out Excel Help > Date and Time Formulas > Add Times :thumb:
 
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...
 
Back
Top