format time in 12hr mode without showing AM/PM

[Chris Green]

Is there a way to format a cell with a generic 12 hour time setup without
showing AM/PM next to the time entered? I need to enter scheduling
information ranging from 8am to 1am without the cell noting AM/PM using 12
hour rather than 24 hour.

 

[David McRitchie]

Hi Chris,
Don't think you can format an Excel time that way.

You could use a formula to change the value like =MOD(x,12)
for an Excel time that would be like =MOD(A1,.5) like in 1/2 day.
A1: 12:45 B1 =MOD(A1,.5) display
note 12 noon would show as 0:00

A practical use of PM numbers in boldface for a bus schedule can
be accomplished via a macro creating a second sheet for display
purpose. The purpose being to show the actual time but conserve space.
Bus Schedule
http://www.mvps.org/dmcritchie/excel/bus_sched.htm