You'll need to use a CASE with LEN to determine what the places mean. Then the SUBSTRING to split out the items.

The issue is that if you have

1101

is that 1:10:01 or 11:00:10 or 1:1:01?

Once you figure out how the algorithm works, you can build a couple CASE statements to clean things up.