Entering time manually is one of the most boring things to do in Excel. Luckily, Excel has some features by which you can easily input time value in your database without wasting your work hour. Today in this article, we will learn some of the methods to enter time in Excel.

**Table of Contents**hide

**Download Practice Workbook**

Download this practice sheet to practice while you are reading this article.

**5 Easy Methods to Enter Time in Excel**

**1. ****Enter Current Time in Excel **

There are many ways to enter the current time in your worksheet. We will learn two of the easiest ways to do it.

**i. Using Keyboard Shortcut to Enter Time **

**Step 1:**

In the given example we have a dataset containing only the names of some candidates. We need to enter the current time in the** â€śStart Timeâ€ť **column by using the keyboard shortcut.

**Step 2:**

Select cell** C4**. Press** â€śCTRL+SHIFT+; (Semi-colon)â€ť** to enter the current time.

- Now copy them down to the end of the dataset.

**Step 3:**

If you want to change the time format to **hh:mm:ss** or **hh:mm:ss AM/PM** you can do it easily. Go to the Number Format Ribbon and click on this icon Â to show all formatting styles.

- In the new window, you can choose your suitable time formats. We have chosen the
**hh:mm:ss AM/PM**format. Click**Ok**to apply this format.

- And our format is successfully applied.

**ii. Using the NOW Function to Enter Time **

**Step 1:**

We can also use the **NOW** function to display the current time. In cell **C4**, apply the **NOW** function. The function is,

**=NOW()**

- Press
**Ok**to get the current time.

**Step ****2:**

The result is in date and time format. Now we can easily change the format by following the procedures that we discussed in the previous method. To do this, open the number formatting window. From there, choose a suitable time format for you.

- Click
**Ok**to apply the format.

**Step 3:**

Now simply copy down the value to the end of the column. Thatâ€™s how you can enter the current time.

**2. ****Using the FILL HANDLE Feature to Enter Time**

**Step 1:**

In the following example, the names of some workers are given and their **â€śStart Timeâ€ť **and **â€śEnd Timeâ€ť** columns are given. Every worker starts his/her work one hour after the previous worker. We have to enter their starting time and ending time using the** Fill Handle** feature.

**Step 2:**

The first value for** â€śStart Timeâ€ť** and **â€śEnd Timeâ€ť** is given. Now click on cell **C4**. Move your mouse to the bottom right corner of the cell until you see the fill handle icon **(+)**.

- Now double click on the fill handle icon to get the time value serially.

**Step 3:**

- Similarly, we can do the same in the
**End Time**column. Select cell**D4**and get the**Fill Handle**icon.

**Double-click**on the icon to get the result.

**3. ****Change Cell Format to Enter Time in Excel**

We can enter time by changing the number format of the cell. Letâ€™s see!

**Step 1:**

In the following example, we are given the time value of some candidates in number format. We will use the formatting options to change those numbers in time.

**Step 2:**

To do it, go to the **Number Format Ribbon**, and click on this drop-down icon Â to open formatting styles. Choose the time formatting.

And our values have turned into time values.

**Step 3:**

Also, you can change the format from the formatting style window.

- Click
**Ok**to get your format.

**Read More:** **Excel Macro: Insert Date and Time in a Cell (4 Examples)**

**Similar Readings**

**Excel Automatically Enter Date When Data Entered (7 Easy Methods)****How to Insert Dates in Excel Automatically (3 Simple Tricks)****Auto populate date in Excel when cell is updated****How to Insert a Date Picker in Excel (With Step-by-Step Procedure)****How to Insert Date in Footer in Excel (3 Ways)**

**4. ****Use TIME Function to Enter Time in Excel**

**Step 1:**

In the given example, **â€śHoursâ€ť, â€śMinutesâ€ť,** and **â€śSecondsâ€ť** are given for some workers. We will have to find their **â€śReporting Timeâ€ť** using those values.

**Step 2:**

In cell **F4** of Reporting Time column, apply the **TIME** function. Insert the values and the final form is,

**=TIME(C4,D4,E4)**

Where, **C4, D4**, and **E4** are the values for hours, minutes, and seconds.

- Press
**Ok**to apply the function.

**Step 3:**

Do the same for the rest of the cells.

**Related Content: How to Insert Last Saved Date in Excel (4 Examples)**

**5. Apply****Â TIMEVALUE Function to Enter Time**

**Step-1:**

In the following example, time values for some candidates are given. We will use **the TIMEVALUE function** to get the time from those values.

**Step 2:**

In cell **D4**, apply the **TIMEVALUE** function. Insert the values and the formula is,

**=TIMEVALUE(LEFT(C4,2)&â€ť:â€ť&MID(C4,3,2))**

Where,

**C4 **is the time value cell and **2** is the number of characters we choose for the **LEFT** function. For the **MID** function, we start from the 3rd character and the number of the selected characters is **2**.

- Press
**Enter**to get the result.

**Step 3:**

Now apply the same formula to the rest of the cells of the column.

**Read More:** **How to Insert Date in Excel Formula (8 Ways)**

**Things to Remember**

âž¤ The results of the** NOW** function changes only when the worksheet is calculated. The date and time that are used are taken from the computerâ€™s system clock.

âž¤ Change the number formatting of the columns before entering time values.

**Conclusion**

Entering time values in excel is quite easy but you have to keep your eye on some conditions to get the job done. We hope this article proves useful to you. If you have any confusion or suggestions, you are most welcome to comment.

**Related Articles**

**How to Insert a Date Picker in Excel (Step by Step Guide)****Insert Date in Excel (7 Simple Methods)****How to Change Dates Automatically Using Formula in Excel****Insert Day and Date in Excel (3 Ways)****How to Insert Drop Down Calendar in Excel (With Quick Steps)****How to Combine Date and Time in One Cell in Excel (4 Methods)**