Conversion from twenty-four hour clock to AM/PM

[mous]

Hello

Is there a function, ideally in a query, that enables a date/time field stored as 13:00 to be converted to 01:00pm for example.

Thanks

 

[Mile-O]

Just set the field's Format to Medium Time.

 

[mous]

Thanks for replying.

First I wanted the field in the query to read 09:00AM and not 09:00 AM before an export to Excel.

I'll just have to tweak the data in Excel to remove the space.

Thanks Anyway.

 

[neileg]

Set the format to hh:mmAMPM

No space will be included.