Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
getting military time format within excel
is there a way to get military time format in excel?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
getting military time format within excel
Sure there is. Use FORMAT - CELLS - TIME and select the military time
format you want. "dgarrison" wrote in message ... is there a way to get military time format in excel? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
getting military time format within excel
You can Custom format a cell as hhmm, so it will show 2250. However, you
still cannot enter it as 2250; you'll have to enter 22:50 If you want to avoid that, see http://www.cpearson.com/excel/DateTimeEntry.htm -- Kind regards, Niek Otten "Barb Reinhardt" wrote in message ... Sure there is. Use FORMAT - CELLS - TIME and select the military time format you want. "dgarrison" wrote in message ... is there a way to get military time format in excel? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
getting military time format within excel
If you're not looking to use code, an old trick is to use "AutoCorrect".
<Tools <AutoCorrect In "Replace", enter " .. " (2 periods / decimals) - (no quotes), In the "With" box, enter the colon " : " (no quotes). You'll find that this is extremely easy for entering times, especially if you're versed in ten key. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Niek Otten" wrote in message ... You can Custom format a cell as hhmm, so it will show 2250. However, you still cannot enter it as 2250; you'll have to enter 22:50 If you want to avoid that, see http://www.cpearson.com/excel/DateTimeEntry.htm -- Kind regards, Niek Otten "Barb Reinhardt" wrote in message ... Sure there is. Use FORMAT - CELLS - TIME and select the military time format you want. "dgarrison" wrote in message ... is there a way to get military time format in excel? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
unhide menu bar in excel - just disappeared | Setting up and Configuration of Excel | |||
Is there an Excel format foro time to hundreths of a second | Excel Discussion (Misc queries) | |||
Every second time i open Excel, it displays the document recovery pane | Excel Discussion (Misc queries) | |||
Excel keeps converting text to date format | Excel Discussion (Misc queries) | |||
Everytime I need to format cells or text, Excel 2003 takes a lot of time or free | Excel Discussion (Misc queries) |