Capture Time with HH:MM:SS using shortkey Ctrl+Shift+:

[MaunishP]

Hi Team,
Whenever i use Ctrl + Shift + :, it is showing HH:MM format only, i want to record seconds also in it. Please provide me a solution to attached file

Regards,
Maunish Patel

 

[Luke M]

I'd write a short macro like this, and then assign it the same keystroke command.

Sub InsertTimeSecs()
ActiveCell.Value = Time
End Sub

 

[MaunishP]

Giving error : Shortkey must be a letter

 

[MaunishP]

Will use letter. Thanks