Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Military Time Data Entry
In Exce 2002, is there any way to format a cell so that you can type 1345 and
have it appear as military time 13:45? Thank you for your help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Military Time Data Entry
Highlight the cells you want this format on... go to
Formate--- Cells---- Number Then select Custom In the Custom menu type ##":"## Then Press Enter "L. Roper" wrote: In Exce 2002, is there any way to format a cell so that you can type 1345 and have it appear as military time 13:45? Thank you for your help. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Military Time Data Entry
I think I might have accidently replied to this question to a different
person... if not this will be the same answer as the previous post... but if not Select all the cells you want that format to show up as Go to Format---- Cells---- Number Select Custom from the list In the Custom field type ##":"## Then press enter. "L. Roper" wrote: In Exce 2002, is there any way to format a cell so that you can type 1345 and have it appear as military time 13:45? Thank you for your help. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Military Time Data Entry
Check this out.
http://www.cpearson.com/excel/DateTimeEntry.htm -- Richard "L. Roper" wrote: In Exce 2002, is there any way to format a cell so that you can type 1345 and have it appear as military time 13:45? Thank you for your help. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Military Time Data Entry
AKphidelt
The operative word being "appear". Your suggested custom format will not actually produce a valid time. You need VBA code for that. See Richard's response with the link to Chip's site. Gord Dibben MS Excel MVP On Tue, 15 May 2007 12:00:01 -0700, AKphidelt wrote: Highlight the cells you want this format on... go to Formate--- Cells---- Number Then select Custom In the Custom menu type ##":"## Then Press Enter "L. Roper" wrote: In Exce 2002, is there any way to format a cell so that you can type 1345 and have it appear as military time 13:45? Thank you for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Military time... | Excel Discussion (Misc queries) | |||
How to keep 0 for military time | Excel Discussion (Misc queries) | |||
Convert data into standard military time format | Excel Discussion (Misc queries) | |||
Show timesheet time in and out in regular time versus military tim | Excel Worksheet Functions | |||
DOS Data in Excel Format with Date and Military Time in same cell | Excel Worksheet Functions |