convert time

[LuisC]

I have a need to convert 28min 25sec into 0:28:25
Suggestions please.....
Thanks

[63falcondude]

Hello and welcome to the forum.

This works for the single sample that you have shared:

=TIME(0,LEFT(A1,2),MID(A1,7,2))

Format as needed.

[63falcondude]

If you could have single digit minutes or seconds (without a 0 placeholder), you can use this:

=TIME(0,LEFT(A1,FIND("m",A1)-1),SUBSTITUTE(RIGHT(A1,5),"sec",""))

[63falcondude]

Just for the fun of it, here's another version that is slightly shorter than the one in post #3:

=SUBSTITUTE("0:"&SUBSTITUTE(A1,"min ",":"),"sec","")+0