Convert military time to 12 hour time

[okaymy1112]

I have data in this format 0800, 1730, 0930, etc.
I do not know how to convert this time to read something like, 8:00AM, 5:30 PM, 9:30AM etc.
Also I want to group things by day. I have courses taken on different days of the week at different time. E.g. Math02 on Wednesday at 8:30 AM to 11:30AM.
So I want to show Time of Day, (eg 6:30 AM - 9:00 AM) Day (eg Monday) ad group the courses taken by day and time.
Please assist
Thanks
O

[missinglinq]

Time is actually stored in Access as, well, time! How it'd displayed depends on how it's formatted.
Short Time (also known as Military time) would be 14:12
Medium Time would be 02:12 PM
Somewhere, either in the table definitions or in the form itself, your times are formatted as Short time. You can change this by changing the format to Medium Time in the table definitions, in the control's property box in the form, or in VBA code

  Format(YourTime, "HH:MM")  'yields 14:12
 Format(YourTime, "HH:MM ampm")   'yields 02:12 PM

As for sorting /displaying classes, assuming you have a record for each class, in your query, make sure Day of Class is to the left, in the Query Grid, of the Time of Class, and sort by both.

Linq ;0)>