adding time

  • Thread starter Thread starter richard
  • Start date Start date
R

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.
 
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.
 
Back
Top