you would want to do that with formating, right click the cell, go to formating and make sure its formated as H:MM, then you can format the cell with AM/PM in it as "AM/PM"