Time conversion

[datastudent]

Hello,

I have this data:

1h 12m 5s
15m 3s
30m
25s

I want to convert it into time format so I can add more formula on it.
My result should be:

1:12:05
0:15:03
0:30:00
0:00:25


Thank you

 

[Fluff]

A brute force option

+Fluff 1.xlsm
	A	B
1
2	1h 12m 5s	01:12:05
3	15m 3s	00:15:03
4	30m	00:30:00
5	25s	00:00:25
Main

Cell Formulas
Range	Formula
B2:B5	B2	=IFERROR(LEFT(A2,FIND("h",A2)-1)/24,0)+IFERROR(MID(A2,FIND("m",A2)-2,2)/1440,0)+IFERROR(MID(A2,FIND("s",A2)-2,2)/86400,0)

 

[datastudent]

Hi @Fluff ,
I tried the formula but I'm having issues with the single digit in minutes like 9m 9s I get 00:00:09. I tried to play with your formula but I still couldn't get it

 

[datastudent]

Hi @Fluff ,
I tried the formula but I'm having issues with the single digit in minutes like 9m 9s I get 00:00:09. I tried to play with your formula but I still couldn't get it

oh wait! Nevermind, I think I got it :D

 

[Fluff]

Glad you sorted it & thanks for the feedback.

 

[datastudent]

Glad you sorted it & thanks for the feedback.

Sorry, I actually didn't get it. I t thought I did but I just encountered a different issue so now I'm back to the same problem which is the single digit in in minutes

 

[Fluff]

How about

=IFERROR(LEFT(A2,FIND("h",A2)-1)/24,0)+IFERROR(MID(" "&A2,FIND("m"," "&A2)-2,2)/1440,0)+IFERROR(MID(A2,FIND("s",A2)-2,2)/86400,0)

 

[datastudent]

How about

=IFERROR(LEFT(A2,FIND("h",A2)-1)/24,0)+IFERROR(MID(" "&A2,FIND("m"," "&A2)-2,2)/1440,0)+IFERROR(MID(A2,FIND("s",A2)-2,2)/86400,0)

YES! It works. Thank you so much. You're the best <3

 

[Fluff]

You're welcome & thanks for the feedback.