Can anyone help. I would like to be able in input into
cells e.g 123456789 and it would display 12:34:56.789 and
be reconised as being in time format. Also a short
version is required i.e. 1234567 would be 12:34:56.7
reconised as a time format.

Hi Kevin,

See Chip Pearsons time entry routines:

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


---
Regards,
Norman



"Kevin" wrote in message
...
Can anyone help. I would like to be able in input into
cells e.g 123456789 and it would display 12:34:56.789 and
be reconised as being in time format. Also a short
version is required i.e. 1234567 would be 12:34:56.7
reconised as a time format.

Have tried that he does not go into the decimal parts of
time, sent him an e-mail got no reply.
Regards
Kevin
-----Original Message-----
Hi Kevin,

See Chip Pearsons time entry routines:


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


---
Regards,
Norman



"Kevin" wrote in message
...
Can anyone help. I would like to be able in input into
cells e.g 123456789 and it would display 12:34:56.789
and
be reconised as being in time format. Also a short
version is required i.e. 1234567 would be 12:34:56.7
reconised as a time format.


.

Try the QDE addin at Ron de Bruin's site:

http://www.rondebruin.nl/qde.htm

if it doesn't do all that you want, send him an email and maybe they will
revise it for you.

--
Regards,
Tom Ogilvy


wrote in message
...
Have tried that he does not go into the decimal parts of
time, sent him an e-mail got no reply.
Regards
Kevin
-----Original Message-----
Hi Kevin,

See Chip Pearsons time entry routines:


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


---
Regards,
Norman



"Kevin" wrote in message
...
Can anyone help. I would like to be able in input into
cells e.g 123456789 and it would display 12:34:56.789
and
be reconised as being in time format. Also a short
version is required i.e. 1234567 would be 12:34:56.7
reconised as a time format.


.

Hi all

Time entry is on the list Tom.

first we want to collect the comments about the first
version of QDE and make the next version perfect<g

The next step is time Entry

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Tom Ogilvy" wrote in message ...
Try the QDE addin at Ron de Bruin's site:

http://www.rondebruin.nl/qde.htm

if it doesn't do all that you want, send him an email and maybe they will
revise it for you.

--
Regards,
Tom Ogilvy


wrote in message
...
Have tried that he does not go into the decimal parts of
time, sent him an e-mail got no reply.
Regards
Kevin
-----Original Message-----
Hi Kevin,

See Chip Pearsons time entry routines:


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


---
Regards,
Norman



"Kevin" wrote in message
...
Can anyone help. I would like to be able in input into
cells e.g 123456789 and it would display 12:34:56.789
and
be reconised as being in time format. Also a short
version is required i.e. 1234567 would be 12:34:56.7
reconised as a time format.


.