How to begin converting Time String to Number or Duration

[Cody_Winchester]

I have a weird one: How would I even begin to convert a column that contains duration data formatted as a string like this? I want the final conversion to be a decimal number, but none of the standard DATETIME() type formulas can make sense of it. Help!

[Cody_Winchester · Accepted solution]

I arrived at part of the solution by following the solution in this thread.