| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time Format...
I'm trying to format a range of cells so that when I enter...
1348 Excel will interpret it as 1:48pm in military time. However, I just can't seem to locate the correct format (if it even exists). Just want to be able to enter the time without the colon and have the system recognize it as a 24-hour format time. Thanx. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Time Format...
See if this is good enough for you:
http://tinyurl.com/r3ngw -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Steven Sinclair" wrote in message ... I'm trying to format a range of cells so that when I enter... 1348 Excel will interpret it as 1:48pm in military time. However, I just can't seem to locate the correct format (if it even exists). Just want to be able to enter the time without the colon and have the system recognize it as a 24-hour format time. Thanx. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Time Format...
Is there any way to accomplish this using ONLY numbers?
Thanx. "Ragdyer" wrote: See if this is good enough for you: http://tinyurl.com/r3ngw -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Steven Sinclair" wrote in message ... I'm trying to format a range of cells so that when I enter... 1348 Excel will interpret it as 1:48pm in military time. However, I just can't seem to locate the correct format (if it even exists). Just want to be able to enter the time without the colon and have the system recognize it as a 24-hour format time. Thanx. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Time Format...
Yes, if you're OK using code.
Check out this link: http://cpearson.com/excel/datetimeentry.htm -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Steven Sinclair" wrote in message ... Is there any way to accomplish this using ONLY numbers? Thanx. "Ragdyer" wrote: See if this is good enough for you: http://tinyurl.com/r3ngw -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Steven Sinclair" wrote in message ... I'm trying to format a range of cells so that when I enter... 1348 Excel will interpret it as 1:48pm in military time. However, I just can't seem to locate the correct format (if it even exists). Just want to be able to enter the time without the colon and have the system recognize it as a 24-hour format time. Thanx. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time Format | Excel Discussion (Misc queries) | |||
| Time format set from VBA | Excel Discussion (Misc queries) | |||
| Converting Text to Time format of XX:XX | Excel Discussion (Misc queries) | |||
| Adding Time Format | Excel Discussion (Misc queries) | |||
| Converting from time format to decimal and figuring the difference | Excel Discussion (Misc queries) | |||
Hybrid Mode
