adding time

[richard]

I want to add times as a value. I make a list of songs
and the time of each song. I want to know how much time
each list of songs will fill. How can I add minutes and
seconds and come up with total minutes and seconds.

 

[Fred Smith]

You just sum them, like any other set of numbers, as in:

=sum(a1:a10)

Format as mm:ss, or [mm]:ss if you might go over 60 minutes in the list.