Function to determine if AM or PM

[gtslabs]

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(A1>12:00,"PM","AM") but that did not work either. Any help would
be appreciated.

 

[Niek Otten]

=IF(A1>0.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


|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(A1>12:00,"PM","AM") but that did not work either. Any help would
| be appreciated.

 

[PCLIVE]

Try this with the time in cell A1:

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

HTH,
Paul