Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format cell as military time
I want to type in 0700 in a cell and press <tab to go to the next cell and
it will auto format it like 07:00 (military time). ex: type in 1400 and it display as 14:00, etc. In other words, I want to be lazy and not have to type the colon. How do I need to format the cell? Thanks... Mike |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format cell as military time
Note that US/NATO military times do not use colons.
To do what you're asking, see http://cpearson.com/excel/datetimeentry.htm In article , Mike wrote: I want to type in 0700 in a cell and press <tab to go to the next cell and it will auto format it like 07:00 (military time). ex: type in 1400 and it display as 14:00, etc. In other words, I want to be lazy and not have to type the colon. How do I need to format the cell? Thanks... Mike |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format cell as military time
JE,
I appreciate the info but I am not familiar with how to set this up. Where do I need to paste that code in my worksheet to make it work? Thanks... Mike "JE McGimpsey" wrote: Note that US/NATO military times do not use colons. To do what you're asking, see http://cpearson.com/excel/datetimeentry.htm In article , Mike wrote: I want to type in 0700 in a cell and press <tab to go to the next cell and it will auto format it like 07:00 (military time). ex: type in 1400 and it display as 14:00, etc. In other words, I want to be lazy and not have to type the colon. How do I need to format the cell? Thanks... Mike |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format cell as military time
Maybe this will help
http://www.cpearson.com/excel/DateTimeEntry.htm -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Mike" wrote in message ... I want to type in 0700 in a cell and press <tab to go to the next cell and it will auto format it like 07:00 (military time). ex: type in 1400 and it display as 14:00, etc. In other words, I want to be lazy and not have to type the colon. How do I need to format the cell? Thanks... Mike |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format cell as military time
See
http://www.mvps.org/dmcritchie/excel/getstarted.htm In article , Mike wrote: I appreciate the info but I am not familiar with how to set this up. Where do I need to paste that code in my worksheet to make it work? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format cell as military time
If your goal is to be lazy, why not just format the cells to military time and then type in "1 pm", "6 am", "11 pm", etc. The output would be: 13:00, 6:00, 23:00. Personally typing 1 pm is faster than typing 1300 since your fingers toggle between numbers and letters. If you want to have 6:00 appear at 06:00 then instead of formatting to time, go to custom and enter hh:mm into the box. -- shadestreet ------------------------------------------------------------------------ shadestreet's Profile: http://www.excelforum.com/member.php...fo&userid=7092 View this thread: http://www.excelforum.com/showthread...hreadid=562200 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format cell as military time
This works for smart as well as lazy people:
http://tinyurl.com/r3ngw -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Mike" wrote in message ... I want to type in 0700 in a cell and press <tab to go to the next cell and it will auto format it like 07:00 (military time). ex: type in 1400 and it display as 14:00, etc. In other words, I want to be lazy and not have to type the colon. How do I need to format the cell? Thanks... Mike |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format cell as military time
Copy the second lot of code from Chip's site.
Right-click on your sheet tab and "View Code" Paste into that sheet module. Gord Dibben MS Excel MVP On Mon, 17 Jul 2006 13:16:01 -0700, Mike wrote: JE, I appreciate the info but I am not familiar with how to set this up. Where do I need to paste that code in my worksheet to make it work? Thanks... Mike "JE McGimpsey" wrote: Note that US/NATO military times do not use colons. To do what you're asking, see http://cpearson.com/excel/datetimeentry.htm In article , Mike wrote: I want to type in 0700 in a cell and press <tab to go to the next cell and it will auto format it like 07:00 (military time). ex: type in 1400 and it display as 14:00, etc. In other words, I want to be lazy and not have to type the colon. How do I need to format the cell? Thanks... Mike |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format cell as military time
However, note that this will also implement the same AutoCorrect in Word
and other Office apps, too. In article , "Ragdyer" wrote: This works for smart as well as lazy people: http://tinyurl.com/r3ngw |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format cell as military time
True, but can't beat it for timecard entry on a Monday morning.
The girls reverse it after they're done. -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "JE McGimpsey" wrote in message ... However, note that this will also implement the same AutoCorrect in Word and other Office apps, too. In article , "Ragdyer" wrote: This works for smart as well as lazy people: http://tinyurl.com/r3ngw |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format cell as military time
Thanks a million to all - this works perfect.
Mike "Gord Dibben" wrote: Copy the second lot of code from Chip's site. Right-click on your sheet tab and "View Code" Paste into that sheet module. Gord Dibben MS Excel MVP On Mon, 17 Jul 2006 13:16:01 -0700, Mike wrote: JE, I appreciate the info but I am not familiar with how to set this up. Where do I need to paste that code in my worksheet to make it work? Thanks... Mike "JE McGimpsey" wrote: Note that US/NATO military times do not use colons. To do what you're asking, see http://cpearson.com/excel/datetimeentry.htm In article , Mike wrote: I want to type in 0700 in a cell and press <tab to go to the next cell and it will auto format it like 07:00 (military time). ex: type in 1400 and it display as 14:00, etc. In other words, I want to be lazy and not have to type the colon. How do I need to format the cell? Thanks... Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell contents with custom time format rounded after double-click | Excel Discussion (Misc queries) | |||
time calculation with military time | Excel Worksheet Functions | |||
Imported Date & Time format with calcs. managed in excel from imrp | Excel Worksheet Functions | |||
can't format cell - have tried unlocking and unprotecting | Excel Discussion (Misc queries) | |||
calculating with a time format cell | Excel Worksheet Functions |