Importing AM/PM Time Format

[JosephS]

I am dumping information into a .txt file from a program that I use from work. This .txt file is set up as a link table in access. Some of the information that is put into the file includes a Time, but it is in the hh:mm AM/PM format. I do not have any control over the format that this comes in.

I am still pretty new to access and I have not been able to get this recognized as a time and can only import it as a text field. Is there any way to have this field recognized as Time so that I can sort my data by this field?

I apologize if this is a dumb question and easy to answer, but I have been unable to find an answer to this question.

Thank you!

Edit: OR... when I send this information to a report, is there anyway to leave the data in the same order as it appears in the .txt file as it is already sorted in the order I need it. I do have the report filtered through the query.

 

[RuralGuy]

Have you looked at the TimeValue() function?

 

[JosephS]

That worked perfectly, with the exception the seconds being included in the format. But I should be able to fix that easily. Thank you very much for the help!

 

[RuralGuy]

Excellent! Glad I could help.