If the cell contains a VALUE rather than text, just change the cell format to

[$-409]h:mm AM/PM;@



"chartasap" wrote:

if i have the time displayed as follows 13:00 PM and want it to be converted
to 1:00 PM, how would i do this?

Thank you!!