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.