How to Enter Time in Excel (With Examples)

The easiest way to enter time values in Excel in a specific format is to use the Format Cells feature.

The following example shows how to do so in practice.

Example: How to Enter Time in Excel

Suppose you have a dataset in Excel that contains the names of various employees at some company and you’d like to enter the time they arrived at work on a particular day:

Suppose you would like to enter the time values in a format such as 6:15 AM.

To ensure that Excel displays the time value that you enter in this specific format, highlight the cell range B2:B13, then right click and then click Format Cells from the dropdown menu:

In the new window that appears, click Time in the Category box, then click the time format in the Type box that represents the time format you’d like to use.

For example, we’ll click 1:30 PM and then click OK:

Now, we can type 6:15 AM into cell B2 and it will displayed in the correct way:

We can then type in all of the check-in times for each employee and they will all be formatted in the correct way:

If you would like the time to also display the number of seconds then you need to choose a different time format using the Format Cells feature.

For example, you could click the format shown as 1:30:55 PM:

Once you click OK, the seconds will then be shown for each time as well:

Feel free to choose whichever time format you’d like using the Format Cells feature in Excel.

Additional Resources

The following tutorials explain how to perform other common tasks in Excel:

How to Subtract Minutes from Time in Excel
How to Format Time with Milliseconds in Excel
How to Convert Decimal Time to Hours & Minutes in Excel

Leave a Reply

Your email address will not be published. Required fields are marked *