AM /PM formula help please
Thank you.
"Ron Rosenfeld" wrote:
On Sun, 2 Sep 2007 17:06:00 -0700, ferde
wrote:
A B
10:29 AM
11:30 AM
18:05 PM
14:45 PM
0:37 AM
I would like to create a formula in column B which looks at column A
and answers the question ..... AM or PM . I have tried some IF formulas
but with no success. Column A is formated in military time (i.e 13:30). I
know I can simply format Column A differently but that wont help me with
further sorting I need to do at a later time.
Any help with this formula would be greatly appreciated.
=RIGHT(TEXT(A1,"h:mm am/pm"),2)
--ron
|