Saturday, December 3, 2011

yogi_Compute Total Play Time Of Songs In An Album In Minutes:Seconds And Not As Hours:Minutes:Seconds

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                  
use loafeye said:
Is there a way to add a column of numbers formatted as times (mm:ss) and NOT as times on a clock?
I want to format a column of numbers (as mm:ss) that are the lengths of songs on an album. Then I want to perform a function to add the column of times and NOT have it revert to something like "0:24" if the first number exceeds 24. E.g.: if I add up 12 song lengths and the total would be 45 minutes and 38 seconds, I want it to display as "45:38" and not revert to "0:38" or some other variation on what it seems to read as an error in the number of "hours". Is there a way to do this?

following is a convoluted soltion to the problem: