Time format

Kevin · Sep 7, 2004

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 · Sep 7, 2004

Hi Kevin,

See Chip Pearsons time entry routines:

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

Guest · Sep 7, 2004

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 · Sep 7, 2004

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 · Sep 7, 2004

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

Time format

Kevin

Norman Jones

Guest

Tom Ogilvy

Ron de Bruin