View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.setup
David McRitchie
 
Posts: n/a
Default format time in 12hr mode without showing AM/PM

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
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Chris Green" <Chris wrote in message ...
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.