I have one custom formula field "Case Age" which displays the Case Age in the format of "xx days yy hours zz mins" which is using the below formula,
TEXT(FLOOR((Case_Custom_Age__c)/(24*60))) + 'd ' + TEXT(FLOOR(MOD(Case_Custom_Age__c,(24*60))/60)) + 'hrs ' + TEXT(FLOOR(MOD(MOD((Case_Custom_Age__c), (24*60)),60))) + 'mins'
But the issue here is, in the List View, it's not sorting properly since it's text datatype and the characters are also appended (actually sorting occurs as per text sorting functionality). I need to sort based on numeric. It should consider all the numeric values. Please help to fix this.