The NOW function in Excel is a formula that shows the current date and time. Any cell in the spreadsheet is changed, a new number or formula is entered in any cell, F9 is pressed. You can use the NOW function in Excel to automatically update the current time in Excel. To insert the current date and time, press Ctrl+; (semicolon), then press the space bar, and then press Ctrl+Shift+; (semicolon).
In the Macros window, select Set Time. After using the shortcut to enter the date and time within a cell, Microsoft Excel will automatically enter the current date and time with the default format set in the system or in Microsoft Excel. ExcelDemy is a place where you can learn Excel and get solutions to your Excel %26, problems related to VBA, data analysis with Excel, etc.