Try this with the time in cell A1:

=IF(A1=0.5,"PM","AM")

HTH,
Paul

--

"gtslabs" wrote in message
...
I have some times that I need a separate cell to look at that time and
tell me if it is AM or PM. I tried using the Right(A1,2) but that did
not work even though I see the PM in the input bar. I also tried
if(A112:00,"PM","AM") but that did not work either. Any help would
be appreciated.