Wednesday, June 15, 2011

yogi_Compute Time For Songs In PlayList

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                  
H-Rod said:
I d' like to sum time cells in that way.
For eg.
I have sheet 1 with column A with title songs and duration son in same cell each one.
Like this!
Song1 - 0:03:20
Song2 - 0:02:45
Song3 - 0:04:10
Song4 - 0:03:20
Song5 - 0:02:45
Song6 - 0:04:10
Now in sheet 2 I have column A with a validation drop menu with sheet1 column A data.
So I select what songs
Song2 - 0:02:45
Song5 - 0:02:45
Song1 - 0:03:20
I want to show and i want show total running time, for eg: in C4 cell in minutes
Sorry my english
Song Collection is in Sheet1
PlayList and the associated Time for songs in PlayList is in Sheet2