HI,

Greetings!!!

I was working on a report and was trying to sort a column containing data like "1 Day 2 hours 3 minutes"..

but when i try to sort i am getting like below,

Actual time left
1 Day 2 Hours 14 Minutes
1 Day 4 Hours 50 Minutes
1 Day 4 Hours 59 Minutes
1 Day 5 Hours 23 Minutes
1 Day 5 Hours 29 Minutes
1 Day 5 Hours 49 Minutes
1 Day 5 Hours 59 Minutes
1 Day 6 Hours 18 Minutes
1 Day 6 Hours 20 Minutes
1 Day 6 Hours 31 Minutes
1 Day 6 Hours 38 Minutes
1 Day 6 Hours 49 Minutes
1 Day 7 Hours 11 Minutes
1 Day 7 Hours 2 Minutes
1 Day 7 Hours 30 Minutes
1 Day 7 Hours 57 Minutes
1 Day 7 Hours 6 Minutes
10 Hours 1 Minutes
10 Hours 12 Minutes
10 Hours 22 Minutes
11 Hours 18 Minutes
11 Hours 5 Minutes
11 Hours 50 Minutes
12 Hours 16 Minutes
12 Hours 2 Minutes
12 Hours 27 Minutes
12 Hours 30 Minutes
12 Hours 51 Minutes
14 Hours
14 Hours 14 Minutes
14 Hours 20 Minutes
14 Hours 24 Minutes
14 Hours 38 Minutes
14 Hours 43 Minutes
14 Hours 49 Minutes
14 Hours 5 Minutes
14 Hours 53 Minutes


the above date is a result which i get after sorting from "Sort A to Z" which is not sorted in correct order.

I spent almost half day in doing this but i can't

Kindly guide me in sorting it in correct format.