Display a schedule of appointments

[lonesomejubilee]

Hi I have a Table in which the person chooses an appointment by time of day (1-2, 2-3, etc). . . broken into categories. How would I display a nice report of that? I want to make it so that one sheet would list all appointments in chronological order. For starters.. the sort doesn't work because it is tricked by the text. I can't seem to figure it out.

[John Mark Osborne]

The easiest approach would be to use a calculatio to convert the time ranges to an actual time result:

Left(TimeOfDay; Position(TimeOfDay; "-"; 1; 1) - 1)

Make sure the result of the calculation is Time. Now you will be able to sort your report by this calculation field. I would have used the LeftWords function to make it easier but it doesn't recognize a "-" as a word separator anymore.