Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Working with times in military/international format.
I enter hundreds of start and stop times to determine room occupancy time. I
would like to get away from inserting the colon in the time, which would greatly enhance entries with the number key pad. How do I format a cell to allow entry of a 4 digit time (e.g. 1955 or 2315) in military/international format? I need to subtract Start from Stop Time, but the answer can be in hh:mm format. Thank You in advance for any helpful suggestions. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Working with times in military/international format.
Chip Pearson has some code he
http://www.cpearson.com/excel/DateTimeEntry.htm which allows you to do that. A quick alternative is to set up autocorrect to change a . to a : and then you can enter the time from the numeric keypad and use a full- stop instead of the colon. Hope this helps. Pete On Apr 8, 1:44*pm, MidWest Yankee <MidWest wrote: I enter hundreds of start and stop times to determine room occupancy time. I would like to get away from inserting the colon in the time, which would greatly enhance entries with the number key pad. How do I format a cell to allow entry of a 4 digit time (e.g. 1955 or 2315) in military/international format? I need to subtract Start from Stop Time, but the answer can be in hh:mm format. Thank You in advance for any helpful suggestions. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Working with times in military/international format.
You could convert the data with=--TEXT(A1,"00\:00")
-- David Biddulph "MidWest Yankee" <MidWest wrote in message ... I enter hundreds of start and stop times to determine room occupancy time. I would like to get away from inserting the colon in the time, which would greatly enhance entries with the number key pad. How do I format a cell to allow entry of a 4 digit time (e.g. 1955 or 2315) in military/international format? I need to subtract Start from Stop Time, but the answer can be in hh:mm format. Thank You in advance for any helpful suggestions. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Military Time Conditional Format | Excel Discussion (Misc queries) | |||
How do I caculate 24 hour military times | Excel Worksheet Functions | |||
Format cell as military time | Excel Discussion (Misc queries) | |||
getting military time format within excel | Excel Discussion (Misc queries) | |||
adding military time format | Excel Discussion (Misc queries) |