TimeStamp macro hh:mm:ss auto entry

[BluVZ]

How to auto-enter timestamp in hh:mm:ss format?

Hi folks,

I'm a basic Excel user...

I need to make a lot of automatic entries in the course of the
day as hh:mm:ss

Like right now it is 07:52:23

I don't want to hit CONTROL+SHIFT+: to get 7:52 AM

And... 07:52:00 (without the accurate seconds is no good either...) That's what happens when I do the CONTROL+SHIFT+: in cells formatted hh:mm:ss

I need it to automatically enter 07:52:23 (without an AM OR PM in the cell)...

My cells are formatted to hh:mm:ss; but I can't get an auto entry.

Is there one??? Or a way to record a macro that will do this? I just recorded my first two macros yesterday for resizing pics in my work and moving them to the right position. Those work great! But I need to have that hh:mm:ss timestamp as well.

Thanks for your help!!!

 

[njimack]

Sub TimeStamp()
With ActiveCell
.NumberFormat = "hh:mm:ss"
.Value = Now
End With
End Sub

 

[BluVZ]

Oh, thank you, Neil!!!!

(I figured out how to set this macro!) It works perfectly!!

Just what I needed! Very grateful for your assistance!!!

B~