Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
format time in 12hr mode without showing AM/PM
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. |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SSN Format not showing | Excel Worksheet Functions | |||
Pie Chart showing Time Zone Comparisons - Can it be done? | Charts and Charting in Excel | |||
Adding Time Format | Excel Discussion (Misc queries) | |||
entering numbers to display a time format | Excel Discussion (Misc queries) | |||
Time Format Auto Entry AM and PM | Excel Discussion (Misc queries) |