Converting Minutes:Seconds to total Seconds

[K.T]

Morning Bubblers

This one is a bit beyond the skills I’ve learned so far - I am getting audio length back as text (e.g. 10:48), how can I manipulate this and get it into total seconds behind the scenes? Effectively I need to change 10:48 in my DB to 648 ((10 minutes x60 +48)).

[code-escapee]

Split by colon. First result * 60 + second result

[Nass]

Yes, something like this should work:

[K.T]

Thank you both for taking the time to reply. @Nass I was able to quickly follow verbatim to get it working brilliantly.

Thanks again!