software

Our office uses a spreadsheet to track test times. I would like to format
the cell to automatically insert the colon when I key (from the number pad) a
time such as 08:37. I tried to format the cell with Format, Cell, Time, Type
(13:30) but it returns 00:00. Thanks for your help.

Formatting the cell hh:mm does not keep you from having to type the colon.
If you omit the column, Excel treats your number as 837.

HTH
--
AP

quot;Bonnie F Moorequot; lt;Bonnie F gt; a écrit dans le
message de ...
gt; Our office uses a spreadsheet to track test times. I would like to format
gt; the cell to automatically insert the colon when I key (from the number
pad) a
gt; time such as 08:37. I tried to format the cell with Format, Cell, Time,
Type
gt; (13:30) but it returns 00:00. Thanks for your help.
Bonnie

Check out Ron de Bruin's QDE(quick date entry) Add-in which allows entering
times and dates with separators.

www.rondebruin.nl/qde.htmGord Dibben MS Excel MVP

On Tue, 25 Apr 2006 06:56:02 -0700, Bonnie F Moore lt;Bonnie F
gt; wrote:

gt;Our office uses a spreadsheet to track test times. I would like to format
gt;the cell to automatically insert the colon when I key (from the number pad) a
gt;time such as 08:37. I tried to format the cell with Format, Cell, Time, Type
gt;(13:30) but it returns 00:00. Thanks for your help.Hi Gord

Not only me(Bob, Frank and Norman also)
It is only working for dates

For time see
www.cpearson.com/excel/DateTimeEntry.htm
--
Regards Ron de Bruin
www.rondebruin.nlquot;Gord Dibbenquot; lt;gorddibbATshawDOTcagt; wrote in message ...
gt; Bonnie
gt;
gt; Check out Ron de Bruin's QDE(quick date entry) Add-in which allows entering
gt; times and dates with separators.
gt;
gt; www.rondebruin.nl/qde.htm
gt;
gt;
gt; Gord Dibben MS Excel MVP
gt;
gt; On Tue, 25 Apr 2006 06:56:02 -0700, Bonnie F Moore lt;Bonnie F
gt; gt; wrote:
gt;
gt;gt;Our office uses a spreadsheet to track test times. I would like to format
gt;gt;the cell to automatically insert the colon when I key (from the number pad) a
gt;gt;time such as 08:37. I tried to format the cell with Format, Cell, Time, Type
gt;gt;(13:30) but it returns 00:00. Thanks for your help.
gt;
Thanks for the clarification Ron and kudos to Bob, Frank and Norman for their
assistance with that project.

You can tell I have not used the QDE add-in or I would have known it quot;doesn't do
timequot;Gord

On Tue, 25 Apr 2006 20:40:01 0200, quot;Ron de Bruinquot; gt;
wrote:

gt;Hi Gord
gt;
gt;Not only me(Bob, Frank and Norman also)
gt;It is only working for dates
gt;
gt;For time see
gt;www.cpearson.com/excel/DateTimeEntry.htm

Gord Dibben MS Excel MVP