Insert times including seconds?
 

How can I include "seconds" when inserting times? I'm using Excel 2000.

thanks.

Insert times including seconds?
 

Enter something like 12:23:24

--

HTH

RP
(remove nothere from the email address if mailing direct)


"joe" wrote in message
...
How can I include "seconds" when inserting times? I'm using Excel 2000.

thanks.

Insert times including seconds?
 

First format the cell as time 13:30:55. Then you can enter time in the same
format.
--
Gary''s Student


"joe" wrote:

How can I include "seconds" when inserting times? I'm using Excel 2000.

thanks.

Insert times including seconds?
 

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(), "h:mm:ss AM/PM")
End Sub


Gord Dibben MS Excel MVP

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

How can I include "seconds" when inserting times? I'm using Excel 2000.

thanks.