AnsweredAssumed Answered

Converting song times to seconds

Question asked by FrankScales on Feb 17, 2012
Latest reply on May 24, 2017 by jdsebastian


Converting song times to seconds


I have a field called duration that shows the length of a song  (example  3:15 which denotes three minutes and 15 seconds). It is currently set as a number field. I'd like to convert it to seconds. I am building a script writing database that will pull in these songs and durations in certain places, and I will need to be able to add the script time (which I do in seconds) with the music duration times.