Insert times including seconds?

[Guest]

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

thanks.

(e-mail address removed)

 

[Bob Phillips]

Enter something like 12:23:24

--

HTH

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

 

[Guest]

First format the cell as time 13:30:55. Then you can enter time in the same
format.

 

[Gord Dibben]

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