I have a need to convert 28min 25sec into 0:28:25
Suggestions please.....
Thanks
I have a need to convert 28min 25sec into 0:28:25
Suggestions please.....
Thanks
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.
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",""))
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks