Convert h m s (text) to excel time for calculation purposes

[domdc1]

Hi there all.... HNY !!!

I have a 100+ line report that is outputted as text. It has a duration column which is displayed as '1h 12m 16s'. I'm trying to convert this column as a workable time output where I can determine averages, max, min etc. I can do that once it is in a time format but the challenge is getting it to that format.

Thanks in advance
Domenic

 

[AlanY]

try this

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"h",":"),"m",":"),"s","")," ","")

 

[domdc1]

Worked great !!!! i was able to change the output to an excel time format & voila !

thanks again

 

[AlanY]

Worked great !!!! i was able to change the output to an excel time format & voila !

thanks again

glad that work for you and thanks for the feed back