format time in 12hr mode without showing AM/PM Chris Green 06.02.2006 21:27:19 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.

Re: format time in 12hr mode without showing AM/PM "David McRitchie" <dmcritchie_xlmvp[ at ]verizon.net> 07.02.2006 00:12:05 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 Green[ at ]discussions.microsoft.com> wrote in message news:40A8BFAB-E984-4721-9BCD-9D973EC70F20[ at ]microsoft.com... [Quoted Text] > 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.