This article demonstrates how to** convert time to number in Excel**. Excel records time as numbers by default. However, due to the formatting of the cells, you frequently see them in multiple formats. Here, we will take you through **5 **easy and convenient methods on how to convert time to number in Excel.

**Table of Contents**hide

## Download Practice Workbook

You may download the following Excel workbook for better understanding and practice yourself.

## 5 Ways to Convert Time to Number in Excel

Suppose you have a list of time ranges. It contains the **Times to Convert into Numbers**.

Now, weâ€™ll convert those times to numbers using various methods in Excel. So, without further delay, letâ€™s jump into the approaches one by one.

### 1. Engaging Format Cells Option to Convert Time to Number in Excel

We can apply the **Format Cells** option to convert our times into numbers. Follow the steps below to understand this method comprehensively.

**đź“Ś**** Steps**

- At first, create a new column in the
**C4:C12**range. Give it a suitable header. In this case, we named it the**Number**column. - Secondly, copy cells in the
**C5:C12**range by pressing**CTRL+C**.

- Now, paste these into cell
**C5**.

- Then, go to the
**Home**tab. - After that, select the
**Number**group. - Next, click on the down arrow in the
**Number Format**box. - Finally, choose the
**General**format from the list.

- At this point, the times are showing as number values.

We can reduce the digits after the decimal to make it look nicer.

- Initially, select cells in the
**C5:C12**range. - Again, go to the
**Home**tab. - Then, select the
**Number**group. - After that, click several times on the
**Decrease Decimal**icon until you get your desired digits after the decimal.

- Finally, we converted the times into numbers. And they look like the one below.

### 2. Using TIMEVALUE Function to Convert Time to Number in Excel

An alternative way to do the same job is to use **the TIMEVALUE function**. Follow the steps below.

**đź“Ś**** Steps**

- At first, select cell
**C5**. - Then, write down the formula below and press
**ENTER**.

`=TEXT(B5,"H:MM:ss")`

Here, **B5** represents the time **8:45:12 AM**.

In this formula, we used **the TEXT function** to convert the time in cell **B5** into a text string.

- Next, use the
**Fill Handle**tool to get the formula in the remaining lower cells.

- After that, select cell
**D5**and type in the formula below. - Then, press the
**ENTER**key.

`=TIMEVALUE(C5)`

Here, **C5** represents the text string **8:45:12** in cell **C5**.

Hence, we used **the TIMEVALUE function** here. This function takes a text string as input. Then, it returns the text string as a representation of time in decimal number format. The decimal value ranges from **0** to **0.99988426**, which corresponds to the hours between **0:00:00** (**12:00:00 AM**) and **23:59:59** (**11:59:59 PM**).

- Finally, the numbers look like the one below.

### 3. Applying Simple Arithmetic Formula

Also, we can assign simple arithmetic calculations. To solve this way, follow the steps carefully.

**đź“Ś**** Steps**

- At the very beginning, select cell
**C6**. - Then, write down the formula below and press
**ENTER**.

`=B6*24`

Here, **B6** serves as the cell reference for the first ** Time** in the list.

In the formula above, we multiplied

**B6**by

**24**as this is the number of

**hours**in a

**day**.

- At this point, go to the
**Home**tab. - After that, select the
**Number**group. - Next, click on the down arrow in the
**Number Format**box. - Finally, choose the
**Number**format from the list.

- Instantly, it looks like the one below.
- Finally, the time is converted into the number of hours.

- After that, use the
**Fill Handle**tool to get the full results.

- Then, select cell D6 and paste down the formula below.

`=B6*1440`

Here, we multiplied the cell reference of **B6** with **1440** as itâ€™s the number of **minutes** in a whole day.

- After that, press
**ENTER**.

- Similarly, we can get the number in seconds.
- At first, select cell
**F6**. - Then, write down the formula below and press
**ENTER**.

`=B6*86400`

In such a situation, we multiplied the value of cell **B6** by **86400**. Because itâ€™s the number of **seconds** in a whole **day**.

- At last, we converted the
**Time**into the**Number**of**Hours**,**Minutes,**and**Seconds**.

### 4. Implementing HOUR, MINUTE, and SECOND Functions

We can use multiple Excel functions at a time to solve this problem. Follow our steps below.

**đź“Ś**** Steps**

- Primarily, select cell
**C6**and put down the formula below.

`=HOUR(B6)+MINUTE(B6)/60+SECOND(B6)/3600`

Here, **B6** serves as the cell reference for the first ** Time** in the list.

**âš™ď¸Ź**** Formula Breakdown**

**HOUR(B6)****âź¶****The HOUR function**returns the hour of a time value. Here,**B6**is the**serial_number**argument. It is the time containing the hour we want to find.**Output****âź¶****8**

**MINUTE(B6)/60****âź¶****The MINUTE function**returns the minutes of a time value. Then, we divided the output by**60**. Because weâ€™re calculating the number of hours. Thus, we know that one hour equals sixty minutes.**Output****âź¶****0.75**

**SECOND(B6)/3600****âź¶****The Second function**returns the seconds of a time value. The second is given as an integer in the range 0 to 59. Thus we divided the output by**3600**to get it in hours.**Output****âź¶****0**

- After that, press the
**ENTER**key.

- Again, select cell
**D6**and put down the formula below.

`=HOUR(B6)*60+MINUTE(B6)+SECOND(B6)/60`

Here, weâ€™re calculating the number in minutes. So, we have to multiply the output of **the HOUR function** by **60**. This converts the value from hours to minutes.

- Similarly, we can convert the
**Time**into a number of**Seconds**. - At first, select cell
**E6**and paste the formula below.

`=HOUR(B6)*3600+MINUTE(B6)*60+SECOND(B6)`

- Then, press
**ENTER**.

- Finally, we converted the
**Time**into**Numbers**of**Hours**,**Minutes***,*and**Seconds**.

### 5. Employing CONVERT Function

A very well substitute to convert time into numbers in Excel is to use **the CONVERT function**. Follow the steps below.

**đź“Ś**** Steps**

- Firstly, select cell
**C6**and write down the formula below.

`=CONVERT(B6,"day","hr")`

Here, **B6** represents the time **8:45:12 AM**.

In this function, the last two arguments are **from_unit** and **to_unit**. **From_unit** is the unit of the input. Whereas, **to_unit** is the unit for the result. In this case, the **day** is the **from_unit** and **hr** is the **to_unit**. This function converts the time of the **day** to just **hours**.

- Similarly, convert the
to*Time*and*Minutes*also using the same function. Just change the*Seconds***to_unit**to**mn**and**sec**respectively.

## Conversion of Time Difference to Numbers

Letâ€™s say, we have a dataset containing the **Start Time** in **Column C**and **End Time** in **Column D **of a certain work. Also, **Column B** holds the **Names** of the individuals who have done the job.

- From the dataset, we calculated the time difference first.
- At first, select cell
**E5**and paste down the formula below.

`=D5-C5`

Here, **C5** and **D5** serve as cell references for the first *Start* and *End Time*. These are **7:40 AM** and **12:25 PM**.

- Then, press the
**ENTER**key.

- At this point, copy cells in the
**E5:E10**range. - Then, go to the
**Home**tab. - After that, select
**Paste**in the ribbon as per the image below. - Later, select cell
**F5**. - Finally, paste the copied data as
**Values (V)**.

- Then, change the cell format as we have done before in
**Method 3**.

- Finally, the time difference is shown as numbers on the sheet.

## Practice Section

For doing practice by yourself we have provided a **Practice** section like below in each sheet on the right side. Please do it by yourself.

## Conclusion

Thank you for reading this article, we hope this was helpful. Please let us know in the comment section if you have any queries or suggestions. Please visit our website **Exceldemy** to explore more.