Enigmachrysalis
Active Member
- Joined
- Apr 13, 2009
- Messages
- 350
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?
Is there a formula to do this?