Add a list of times

J

jmcclain

I need to add the lengths of various songs for our hold music.

Such as 3:42 + 3:02 + 4:54, but need it to sum into the same format.

Any help is appreciated.

Thanks

Jon
 
P

Peo Sjoblom

How about

=SUM(A1,A3,A7)

or if possible

=SUM(A1:A7)

finally make sure the cell with the formula uses a custom time format like

[mm]:ss

or if indeed you just entered 3 minutes and 42 seconds 3:42 and not

0:3:42

then use


[hh]:mm
 
Top