Convert alphanumeric uration into HH:MM:SS

[Anonymous]

Hi ,

I have a excel having the time duration in alphanumeric (e.g. 1h30m , 2h) . I want to convert duration into HH:MM format .

Please help me on the same .

Thanks,

Vals

[Anonymous]

Thanks , It worked but this will create problem further while calculating the Sum in minutes or in hours ..!

[adamdavi3s]

Not really as you have a timestamp field which is very easy to work with in Qlik!