=IF(A10.5,"PM","AM")

Works if there is only time in A1, not a date too. You can check by formatting A1 (temporarily) as general; it should be less than
1.

If there is a date part:

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"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.