Convert String To Time Duration In Excel [duplicat

Question

This question already has an answer here:

• Converting Time Formats in Excel 2 answers

May I know the way to convert "1 h 49 m 57 s" to 1:49:57 in Excel. Thanks in advance

Answer 1

You can use this formula to replace letters to colons then convert text to value:
=VALUE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A5," h ",":")," m ",":")," s",""))

After inserting the formula set the cell's number format to "time".