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.