Sequential Appointments In Appointment Calendar

[bigcity]

I am trying to get the monthly appointment calendar that I have created to list the appointments by time and not by being created. If I make an appointment at say 2:30 PM and then make an appointment at 9:00 AM the 2:30 PM comes before the 9 am one. Is there a js for this that will make the calendar be time sensitive?

[MayMusic]

Did you sort the report by this field? Is it a date field or text field?

[bigcity]

it is a text field

[MayMusic]

Try to add a date field and then use it to sort the data, the way that text is being sorted is different