Question

I have a database with a text property called Time Spent. I need to convert the text to minutes.

Time Spent
2:12
00:20 | 1:45
1:34 & 2:34 & 3:00
00:45 - 1:11 - 1:33 - 00:12

So far, I can only convert the first row to minutes using this formula:

toNumber(prop("Time Spent")) * 60 + toNumber(replace(prop("Time Spent"), "[^ ]:", ""))

replaceAll(prop("Time Spent"), "[&|-]", "")

removes the strings/characters that I want between the hours:minutes but I'm still stuck on how to convert after removing those characters.

I really appreciate any help you can provide.