F
ferde
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.
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.