Time conversion

[daverunt]

I'd like to convert a time string. I'm using a macro to extract the string from a text file and need to modify the string format within the macro.
Modifying the target cell to a time format is not possible.

hhh:mm:ss - this is always the number of characters
to text format that excludes empty values

For example 000:05:00
Would output 5m

001:10:08
Would output 1h 10m 8s



Any help appreciated.

 

[Rick Rothstein]

Just wondering... did you really mean to mark your post as the answer?

 

[daverunt]

No.
Should be the right one now.