Enter Current Time In Excel

Using Shortcut Key:

Ctrl + Shift + ; (semi-colon key)

Output:

6:25 PM

Steps:

To add the current Time to a worksheet using just the keyboard:

1. Click on the cell where you want the Time to go.


2. Press and hold down the Ctrl + Shift key on the keyboard.


3. Press and release the semi-colon key ( ; ) on the keyboard without releasing the Ctrl + Shift key.


4. Release the Ctrl + Shift key.


5. The current time should be added to the worksheet in the selected cell.

Using Function:

 =Now()

Output:
 3/5/2014 18:28

Now Set the format of Cell to Time by right click on cell and select Formate Cells.. Then select Time from left hand side and select your time format now its display like 6:28:44 PM

Note:
As a result the function continually updates itself every time a worksheet is recalculated.

Normally worksheets recalculate each time they are opened so every day that the worksheet is opened the date will change unless automatic recalculation is turned off.