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.
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.