Time Group Order

[bv0719]

Hello,

I created a formula to break out the hours in a workday. Then I created a group based on the formula.

formula:
if time({invdth.idhedt}) in time(0,0,0) to time(5,59,59) then "12am - 6am" else
if time({invdth.idhedt}) in time(6,0,0) to time(6,59,59) then "6am - 7am" else

Etc...

When I group on the formula the sorting is incorrect. All of the times starting with a "1" are first and so on. What is the answer to this problem? I haven't found any group sorting options that will correct this. Must be a formula error.

example:
10am - 11am
11am - 12pm
12am - 6am
12pm - 1pm
1pm - 2pm
2pm - 3pm

etc..

Thanks,
Bill V

 

[lbass]

When you insert the group, choose specified order, and then add each time in the order it should appear.

-LB

 

[bv0719]

Lb,

Glad to see you replied. I used your formula from another post to create the group. Thought there may be a way to specify the order in the formula or change the "time ranges" so they sort better. But, using specified order will work too.

Thanks again.

BV