December 4, 2020

How to Insert current time in a cell in excel

In our excel worksheet we need to insert the current time in cell A2.

  • Select the cell A2
  • Press Keyboard Shortcut
    Ctrl+Shift+:
  • See below the current time has been inserted in cell A2.

  • Now if you need to change the format of the time, you can right click on the cell and go to ‘Format Cells’.

  • Select the Time format as required from the available formats in Time category in Format Cells pane.

Leave a Reply

Your email address will not be published. Required fields are marked *