Converting Minutes:Seconds to total Seconds

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)).

Split by colon. First result * 60 + second result

1 Like

Yes, something like this should work:


1 Like

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

Thanks again!

1 Like

This topic was automatically closed after 70 days. New replies are no longer allowed.