Extract AM/PM as text from date/time?

[Enigmachrysalis]

I have a column of times, that are actually dates of 1/0/1900 plus time, from which I want to extract the AM or PM status. I can format it to show this, but it's really just a fraction of a day. I need the actual text "AM" or "PM", not a decimal value.

Is there a formula to do this?

 

[z168]

SEARCH function rules!!!!

not the exact question I had in mind but works

 

[jimmy90]

Kind of an old thread but since it is a top a google search I though I might add another solution.

=TEXT(A1,"AM/PM")

Will return the Am or PM portion of the time in Cell A1