Convert number with text to number

Hi SenoirB 

I modified AntrikshSharma 's solution as below. You can use this code to create a custom column. 

let result = 
    Text.Replace ( 
        Text.Replace ( 
            Text.Replace ( 
                Text.Replace ( [Time], " ", "" ), 
                "h", "*60+" 
            ), 
            "m", "*1+"
        ), 
        "s", "/60" 
    ) 
in
if Text.EndsWith(result, "+")
then Expression.Evaluate(Text.Range(result, 0, Text.Length(result)-1)) 
else Expression.Evaluate(result)

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.