I have a spreadsheet that comes with 1h 20m 30s in a column named downtime. I am trying to convert the format to 00:00:00 but am not having much luck. I have tried text to coulmns to remove the h,m or s but I run into issues because if the time is less than an hour it doesnt have the h, or if its on seconds it will be displayed as 56s for exmaple.
Any help would be greatly appreciated.
Thanks
Examples:
Downtime
1m 14s
3m 48s
1h 24m 50s
7s
Any help would be greatly appreciated.
Thanks
Examples:
Downtime
1m 14s
3m 48s
1h 24m 50s
7s