Sort values by hours and days

time_to_purchase 0 - 6 hours 1 - 3 days 10 - 20 days 12 - 18 hours 18 - 24 hours 20 - 30 days 3 - 5 days 30 - 45 days 45 - 60 days 5 - 10 days 6 - 12 hours 60 -...

excel

nimesht
Aug 02, 2023
Hi akshay2023,

You cannot sort this data directly since it has mutiple units. What you need to do is create another helper column for sorting purpose which will have all the data in single unit, i.e. everything in hours or everything in days.

Refer the below example where I've converted everything in days considering the upper end of the value. You can generate the values for this helper column either by typing manually or using formula to check hours/days in the main column.

nimesht

Iron Contributor

Aug 02, 2023

Hi akshay2023,

You cannot sort this data directly since it has mutiple units. What you need to do is create another helper column for sorting purpose which will have all the data in single unit, i.e. everything in hours or everything in days.

Refer the below example where I've converted everything in days considering the upper end of the value. You can generate the values for this helper column either by typing manually or using formula to check hours/days in the main column.

akshay2023

Copper Contributor

Aug 21, 2023

nimesht Thanks! This solution works for me.

Forum Discussion

Sort values by hours and days

Resources