excel - Convert format 0d 22h 41min to a time in any format using a formula -

I have a column of data that I want to sort the latest according to the latest on time.

The format of the data is presented in this form:

0d 22h 41min,

0d 2h 3min

etc.

What's the best way to do this? I am anticipating the removal of numbers, 0, 22 and 41, and then use a calculation to change it in minutes, then will I allow it to be reordered?

Please consult the best way, and then you can do the formula.

Consistent with data in A2, assuming day hours and minutes, See in 2 to change to a time value:

= SUM (MID (0 and A2, FIND ({"d", "h", "m"}, 0 and a 2) -2.2) / {1,24,1440})

Show total hours and minutes for custom format B2 to [h]: mm ...... and then you can sort both columns using "B" in the form of "key" - will deal with big values ​​as 99 days - higher Try this version for

= Left (A2, FIND ("D", A2) -1) + Yoga (Middle (A2, FIND ({"h", " M "}, A2) -2.2) / {24,1440})