Forum Discussion

jenni1987's avatar
jenni1987
Copper Contributor
Jan 14, 2024

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 shows for ss= 00 every time. F.e. in google sheets in germany i press strg+shift+รถ and it works. Please help me to find the excel way. I need this for SLA statistics at work. Entering the time manually takes to long and leaves space for mistakes.

 

Thank you!!

  • jenni1987 

    You might create a macro

    Sub EnterNow()
        On Error Resume Next
        ActiveCell.Value = Time
    End Sub

    Assign 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.

    • jenni1987's avatar
      jenni1987
      Copper Contributor

      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.

  • jenni1987 

    Another option seems to be to use data validation.  The validation list would comprise a single cell containing

    = MOD(NOW(),1)

    maybe with number formatting so that the dropdown list shows "insert current time".

Resources