I need to convert the info in the Raw Data Column to the displayed info in column I.

Is there any formula that can accomplish this?

CodePudding user response：

try:

=ARRAYFORMULA(IF(A2:A10="";;TEXT((
 IFNA(REGEXEXTRACT(A2:A10; "(\d )h")*3600) 
 IFNA(REGEXEXTRACT(A2:A10; "(\d )m")*60) 
 IFNA(REGEXEXTRACT(A2:A10; "(\d )s")))/86400; "[hh]:mm:ss")))