I have some times that I need a separate cell to look at that time and
tell me if it is AM or PM. I tried using the Right(A1,2) but that did
not work even though I see the PM in the input bar. I also tried
if(A112:00,"PM","AM") but that did not work either. Any help would
be appreciated.