current time

D

dummy

When I use (ctrl+shft+;) to get the current time it always displays the
seconds as 00. Is there any way to get the seconds also?
Thanks
 
B

Bernard Liengme

That is the accuracy of the procedure. If you want more, use =NOW()
best wishes
 
M

Ms-Exl-Learner

But in the Now() function the time will be keep on changing to the current
system time, so you can use a small Time Macro To capture the Current Timing
with seconds.

Press ALT+F11 and go to Insert and click Module and paste the below code.

Sub Cur_Time()
ActiveCell = Time
End Sub

After pasting the code close the VBA and press ALT+F8, the Cur_Time Macro
will appear. Just select it and select Options and give your desired
keyboard button as shortcut key to run the macro.

If this post helps, Click Yes!
 
Top