I have a problem i cannot seem to solve,

In a column i have time noted as tekst in the format mm:ss and i cannot use it in formulas. I need to add all the time and for this i need to change it to numbers, change the : for a comma and make for instance 30 second to ,5 minutes.

Does anyone have an idea to doe this? I have 1 column and about 5000 rows.. so by hand is not an option!

Kind regards!

Text To Time.xlsx