| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding the semicolon automatically in date format
I use Excel to enter the start and end time of an employee and the 3rd cell calculates the number of hours worked. The formula works great, however it would be so much faster if I could avoid having to type the ":" each and every time. Is there a way to add the semicolon automatically, or alternately have the ability to type "1400" and have it see "14:00"? Thanks very much, James Norton -- ThereJustNow ------------------------------------------------------------------------ ThereJustNow's Profile: http://www.excelforum.com/member.php...o&userid=35720 View this thread: http://www.excelforum.com/showthread...hreadid=555035 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I format a cell to a date format? | Excel Discussion (Misc queries) | |||
| Break links automatically changes graph's date format | Excel Worksheet Functions | |||
| Customized Date Format | Excel Worksheet Functions | |||
| format date in excel | Excel Discussion (Misc queries) | |||
| prevent 4/5 in a cell automatically transfer to a date format | Excel Discussion (Misc queries) | |||
Threaded Mode
