software

How can I include quot;secondsquot; when inserting times? I'm using Excel 2000.

thanks.
Enter something like 12:23:24

--

HTH

RP
(remove nothere from the email address if mailing direct)quot;joequot; gt; wrote in message
news
gt; How can I include quot;secondsquot; when inserting times? I'm using Excel 2000.
gt;
gt; thanks.
gt;
gt;
First format the cell as time 13:30:55. Then you can enter time in the same
format.
--
Gary''s Studentquot;joequot; wrote:

gt; How can I include quot;secondsquot; when inserting times? I'm using Excel 2000.
gt;
gt; thanks.
gt;
gt;

joe

How are you inserting the time?

SHIFT CTRL ; will always insert just the hour and minute and 00 seconds.

To have hour, minute and seconds you need a macro.

Sub NOWTIME()
ActiveCell.Value = Format(Now(), quot;h:mm:ss AM/PMquot;)
End SubGord Dibben MS Excel MVP

On Wed, 11 Jan 2006 14:56:02 -0800, joe gt; wrote:

gt;How can I include quot;secondsquot; when inserting times? I'm using Excel 2000.
gt;
gt;thanks.
gt;