I would like to avoid using the colon when entering a time. Can a cell be formatted to read the a military time like 1525 (not 15:25) and convert it to 3:25pm?

Thanks in advance