How to Enter a Time

Time format in Excel by default is "HH:MM:SS", but they can be formatted into different styles.

– How to Enter a Number
– How to Enter a Fraction
– How to Enter a Date
– How to Enter Text Content

1. To Enter a Time

For example, to enter a time of "4:20:15":

Step 1: Select a cell and type the hour "4" from the keyboard

Step 2: Type the time separator: ":" (colon)

Step 3: Enter the minute by type "20"

Step 4: Type another colon separator

Step 5: Enter Second (e.g., 15)

Step 6: You can format to a different style, please check how to format time into different styles.

The time format in the formula bar will not changed even you changed to a different format in the cell.

2. To Enter Current Time

To enter current time, you can use:

– Excel function of "=NOW()", or

– Excel shortcut of "Ctrl+Shift+:" (colon).

"=NOW()" will have us the time with today's date while the shortcut will have us only the time.

Leave a Reply