MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

EXCEL Question

  Asked By: Shruti    Date: Feb 07    Category: MS Office    Views: 886

Question with MS Excel.

Have put my music CD collection in a spreadsheet, and want to total the
playing times.

Columns look like this:

Track | Playing Time
Track 1 | 4:03
track 2 | 2:25
track 3 | 3:18

Total | ?

I want to show the total length as 9:46 Is this possible? What formula
is required?



1 Answer Found

Answer #1    Answered By: Shruti Sharma     Answered On: Feb 07

Format the column that contains the times as a "time"
To do this right-click on the column and select format cells..
Then under the Number Tab Select time from the Category List box

Now all you have to do is sum the column in the cell you want the total
i.e.: =SUM(C2:C10) would be placed in C11 if your times were entered in
the C column

Didn't find what you were looking for? Find more on EXCEL Question Or get search suggestion and latest updates.