How to Insert Time Into an Excel Spreadsheet

Static Time
1. Select the cell where you wish to enter the time.
2. Press 'Ctrl' 'Shift' ';'.
3. Click the 'Format' menu and select the 'Cells' option.
4. Click the 'Numbers' tab.
5. Select 'Time' from the drop-down list and select your preferred format in the second column. You can also create a custom display format. When you're finished, click 'OK.'
Dynamic Time
6. Select a cell in your spreadsheet and type '=NOW()' into the cell.
7. Press 'Enter.' The time and date are displayed in the default format.
8. Change the format by following steps 3 to 5 in Section 1.