enter current time with seconds

  • Thread starter Thread starter cpliu
  • Start date Start date
C

cpliu

Control-Alt-; enters the current time but it does not have a second
information. Is there a setting that it will include the second
information?

Thanks,
 
CTRL + SHIFT + ; enters the current time.

No, seconds cannot be included.

You need a small macro for that.

Sub NOWTIME()
ActiveCell.Value = Format(Now(), "h:mm:ss AM/PM")
End Sub


Gord Dibben MS Excel MVP
 
Back
Top