enter your times as 3:40 or 12:30 and set the format of the cell to show
it as am or pm

format ,,,, cells,,,,custom,,, h:mm AM/PM


"WNB-96740" wrote:

If I input - "340 a", I want it to show "3:40 AM"

or if I input 1230 p, I want it formated as 12:30 PM

can this be done?