Sort By Time With Variable Start

[mikeytt]

Hi, not sure if this is possible but would greatly appreciate any ideas...

My records have a TIME field.

I want to be able to sort on this field, BUT, want to have a START time which the user can select. This would determine where the Sort would begin from.

For exmaple, with the following 5 times: 03:00, 06:00, 09:00, 22:00, 23:00

a standard sort gives: 03:00, 06:00, 09:00, 22:00, 23:00

but if the users decided that the Day Starts at 08:00, then the sort would return: 09:00, 22:00, 23:00, 03:00, 06:00

so it is kind of rolling sort.

Any ideas how I can go about this?

[comment]

Define a calculation field =

Mod ( Timefield - gStartTime ; 86400 )

Use this field for sorting. Note that sorts using an unstored calculation will be a tad slower.

[mikeytt]

That's perfect, and so simple! thank you