How to sort this hours in ascending order!

[Anonymous]

Hi ,

I got this strange bit of sorting the hours in ascending order.

I have used the sort option increase ascending order by hours . But still cant win.

Any one can help pls.

This is the screen shot

[PrashantSangle]

hi,

try sorting with expression,

use below expression -> pick(match("0-1Hrs","10-11 Hours",....))

Regards,

[Chanty4u]

it is excel? if yes go for custom sort

if it is in qlik  try below

=match(DimensionField,'value1','value2','value3')

[Anonymous]

Hi,

It is working fine at Qlik by sorting at the table level.

But i am wondering how do you write that expression at nprinting.

[Anonymous]

yes it is in excel. as i am doing the reporting in nprinting.

Can you elaborate on custom sort?

[PrashantSangle]

check sureshqv‌ answer..

Regards,

[Chanty4u]

select the column and select the sort &filter   icon in excel home page

and in that you will find the custom sort write your order and use the same.

[PrashantSangle]

check below url for better understanding

https://www.extendoffice.com/documents/excel/897-excel-sort-columns.html

Regards

[Anonymous]

Strange,I cant able to see that sort by option.

[Chanty4u]

select single cell then only you can able to see