Time format

[Kevin]

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.

 

[Norman Jones]

Hi Kevin,

See Chip Pearsons time entry routines:

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

 

[Guest]

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

 

[Tom Ogilvy]

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.

 

[Ron de Bruin]

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