I am importing data from an Excel spreadsheet
Import From (m.xlsfile) Type Xl8 Sheet "new order file"
Which creates a new .dbf with fields "a", "b", "c", etc.
In the original spreadsheet is a field whose contents represent a time...
9:00:00 PM
...however, once it's imported it looks like this...
12/30/99 09:0
...then further down in my code I use the value scattered from the new .dbf and attach this information to some text (field name=P)...
comment3="Hard Start Time: "+Alltrim(M.p)+'. '
...and the value of comment3 becomes
Hard Start Time: 9:00:00 AM.
I have no idea where the AM part is coming from. Can anyone explain to me what's happening here and/or just how to get it to reflect AM/PM correctly?

Thanks,
Martha