Use a formula

-IF(A2<.5,"AM","PM")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"dar" wrote in message
...
I may be going at this the wrong way; However, I have a spreadsheet that
has
two columns labeled "Time" and "AM/PM". I need the AM/PM for which
Access
uses to sort report from. ( I import excel into Access)
The problem is various users input into excel and don't always place the
AM/PM into appropriate cell which causes errors upon import.
I would like to create macro which will fill in am/pm if there is a time
listed in the
"Time" column.
Any help would be appreciated.