View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default Is there a way to enter times without typing a colon?

Hi Dennis,

http://xldynamic.com/source/xld.QDEDownload.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"dk_" wrote in message ...
| 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