| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a way to enter times without typing a colon?
It there a way to enter times without 'typing' a colon in an empolyee
time sheet, and still be able to add the number of hours worked? ....For example, type 0930 and 2130 instead of having to type either 9:30 or 09:30 and 21:30, and still be able to do the math on figuring the number of hours worked in a day? Thanks. -Dennis -- Dennis Kessler http://www.denniskessler.com/acupuncture |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I enter a date typing 040906 and have it appear 04/09/06? I | New Users to Excel | |||
| Why do I lose hundredths when summing elapsed times in a pivot tab | Excel Discussion (Misc queries) | |||
| Avg Times in MOD fx using selected rows | Excel Worksheet Functions | |||
| typing addresses & when I hit enter need to be on next line cel B | Excel Discussion (Misc queries) | |||
| How do I enter minutes and seconds (lap times)? | Excel Discussion (Misc queries) | |||
Threaded Mode
