times in order

[#1]

Hi,

Can anyone highlight how we can get the follwoing times to go in order:

Standrad sorting of frequency, text order etc wont work. It needs to be in order of time, earliest to latest

Q2. What   time do you leave work on average? / Q2. Response	No of responses
	193
5:00 - 5:30pm	51
4:30 - 5:00pm	67
6:00 - 6:30pm	12
5:30 - 6:00pm	21
6:30 - 7:00pm	2
4:00 - 4:30pm	33
7:00 - 7:30pm	7

Chris

[Nicole-Smith]

Sort tab > Sort YourTimeField by Expression:

wildmatch(YourTimeField, '4:00*', '4:30*', '5:00*', '5:30*', '6:00*', '6:30*', '7:00*')

[#3]

Hey Chris,

If the From - To times are two separate fields then you can just sort them using From. Possible to attach a sample file.

Thanks

AJ

[#4]

Hi,

I thought kind responses worked; however, doesnt seem to be working correctly.

Please see atatched app with the three charts and tables we would like the sorting to work for.

Chris

[rbecher]

Use this expression:

Time#(subfield([Q1. What time do you get into work on average?],' -',1), 'h:mm')

[maxgro]

change the field and use Nicole answer, in that way

wildmatch([Q1. What time do you get into work on average?], '4:00*', '4:30*', '5:00*', '5:30*', '6:00*', '6:30*', '7:00*') 

regards

[rbecher]

..change to the Dimension field for the other charts.