Forum Discussion
short cut entering time incl. the seconds
Hi Team, i am looking now since hours for an option to enter the actuel time incl. the seconds. hh:mm:ss. The cell is formated like this. Entering the time with strg+shift+. only enters hh:mm and sh...
You might create a macro
Sub EnterNow()
On Error Resume Next
ActiveCell.Value = Time
End SubAssign the macro to a custom keyboard shortcut and/or Quick Access Toolbar button for ease of use.
If you prefer to enter the date + time, use Now instead of Time.
You'll have to save the workbook as a macro-enabled workbook and to allow macros when you open it.
HansVogelaar thank you for this. I never did before but will try. Therefor i need to use excel on desktop right (not online)?
I will let you know if it worked tomorrow.
