View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
dk_ dk_ is offline
external usenet poster
 
Posts: 70
Default Is there a way to enter times without typing a colon?

The code on Chip Pearson's page, (link below), was exactly what I was
looking for. Sorry if I didn't ask my question properly.

....From Ron Coderre's post to another similar question:

See Chip Pearson's website for options:

http://www.cpearson.com/excel/DateTimeEntry.htm

Does that help?
***********
Regards,
Ron



-Dennis

--
Dennis Kessler
http://www.denniskessler.com/acupuncture



In article ,
"Niek Otten" wrote:

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