Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
dgarrison
 
Posts: n/a
Default getting military time format within excel

is there a way to get military time format in excel?
  #2   Report Post  
Posted to microsoft.public.excel.misc
Barb Reinhardt
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Ragdyer
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
unhide menu bar in excel - just disappeared Sean Setting up and Configuration of Excel 12 April 4th 23 10:19 AM
Is there an Excel format foro time to hundreths of a second teetime Excel Discussion (Misc queries) 2 December 1st 05 03:25 AM
Every second time i open Excel, it displays the document recovery pane Paliente Excel Discussion (Misc queries) 3 September 14th 05 01:53 PM
Excel keeps converting text to date format John T via OfficeKB.com Excel Discussion (Misc queries) 4 September 12th 05 06:48 PM
Everytime I need to format cells or text, Excel 2003 takes a lot of time or free Florimar Agostini via OfficeKB.com Excel Discussion (Misc queries) 1 April 1st 05 06:29 AM


All times are GMT +1. The time now is 08:51 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"