current time

[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

 

[Bernard Liengme]

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

 

[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!

 

[JAF-In]

Format the cell in custom as hh:mm

 

[David Biddulph]

And how does that get the seconds to be non-zero?