I am trying to extract numbers from a string(s). The challenge for me is the string is never constant so the RIGHT or LEFT functions will not work for every situation. Here is an example of the string(s):

9m
2d 17h 35m
6h 19m
12h 21m
28m

For the LEFT/RIGHT functions to work I need the formula to return this:

0d 00h 09m
2d 17h 35m
0d 06h 19m
0d 12h 21m
0d 00h 28m

My desired end result is this so I can add the time to NOW() and know exactly what day/time a deadline ends:
:9
2:17:35 (I multiply the day number by 24 to get hours for time addition)
6:19
12:21
:28


Thanks in advance for the help,

Keyrookie