Insert times including seconds?

B

Bob Phillips

Enter something like 12:23:24

--

HTH

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

Gary''s Student

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

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
 
Top