How to insert current time in Excel

How to insert a static time in Excel

If we want to insert a static time value in Excel, we can use short cut key combination "Ctrl" + "Shift" + ";" (semi-colon).

Current time is inserted in Excel Cell as shown below.

How to insert dynamically changing time in Excel

Sometimes, you may need to insert dynamically changing time in Excel. Dynamically changing time updates its value when a workbook is opened or recalculated.

To insert dynamically changing time, you need to use Excel in-built function NOW(). Below image shows how to use NOW() function to insert dynamically changing time in Excel.