How to add AM/PM to a cell

[keithjones33]

I have an excel spreadsheet which I am trying to improve. One of the columns is based on whether a shift was a morning shift (AM) or an afternoon shift (PM). currently it is using a data validation and I have to pick from a drop down list. Is there a formula that automatically inputs either AM or PM based on the systems clock. I have tried a few things but nothing works, do I have to use VBA which I am a complete novice.

Thanks

 

[bugmonsta]

Hi,
You could format your cells to a custom format of h:mm AM/PM, if you use a 24hr clock it will automatically add the AM/PM to the time for you

14:00 becomes 2:00 PM and 02:00 or 2:00 becomes 2:00 AM

 

[keithjones33]

Hi,
You could format your cells to a custom format of h:mm AM/PM, if you use a 24hr clock it will automatically add the AM/PM to the time for you

14:00 becomes 2:00 PM and 02:00 or 2:00 becomes 2:00 AM

Thanks bugmonsta. Not quite what I want to do. I just want to show AM or PM (not the time) based on the system clock. for example if the clock is showing between 00:01 and 11:59 I want the cell to show just AM, if the clock shows between 12.00 and 12:00 then I want the cell to show just PM.

 

[FormR]

Hi, you could try:

=TEXT(NOW(),"AM/PM")

 

[keithjones33]

Hi FormR, that worked a treat. Thanks. I didn't think of using "Text" formula. Again thanks