A lot of times, we work with **Time **in **Excel **worksheets. The input of office entry time, exit time, and calculating working duration in a specific format are essential in many companies. **Excel **can help us easily in this respect. **Excel **provides various **Time Formats**. We only need to choose our desired format for the time inputs and the time unit for the duration count. In this article, we’ll show you the easy and effective methods to **Convert Hours **to **Decimal **in **Excel**.

**Table of Contents**hide

## Download Practice Workbook

Download the following workbook to practice by yourself.

## 3 Easy Methods to Convert Hours to Decimal in Excel

We know, there are **2 Time Formats **in practice, **12-hour** and **24-hour** formats. In our article, we’ll use the **12-hour** formats with **AM / PM**. To illustrate, we’ll use a sample dataset as an example. For instance, the following dataset represents the **Time **in **12-hour** formats. Here, we’ll transform the input time into hours with decimals.

### 1. Convert Hours to Decimal in Excel with Simple Formula

In our first method, we’ll use a simple formula. We know that a day completes in **24** hours. Here, we’ll use this fact. Therefore, follow the steps below to perform the task.

**STEPS:**

- First, select cell
**C5**. Here, type the formula:

`=B5*24`

- Then, press
**Enter**. Thus, it’ll return the calculation. - After that, use
**the AutoFill tool**to complete the rest of the series.

- Now, select the range
**C5:C8**for converting them to decimal.

- Next, press the keys
**Ctrl**and**1**at the same time. - As a result, the
**Format Cells**dialog box will pop out. - There, select
**Number**in the**Category**section under the**Number tab.**

- Subsequently, press
**OK**. - Finally, you’ll get to see the desired output which is hours with decimals. Observe the below image for a clear understanding.

**Read More: Converting Time to Decimals in Excel (4 Examples)**

**Similar Readings**

**How to Convert Decimal to Days Hours and Minutes in Excel (3 Methods)****Convert Decimal to Minutes and Seconds in Excel (3 Easy Ways)****How to Fix Decimal Places in Excel (7 Simple Ways)****Insert Dot between Numbers in Excel (3 Ways)****How to Remove Decimal Places in Excel (5 Easy Methods)**

### 2. Combine HOUR, MINUTE & SECOND Functions for Transforming Hours

Moreover, **Excel **provides some **Time Functions** by default that are helpful. **The HOUR function** gives a number as an hour (**0** to **23**), **the MINUTE function** will return a number as minutes (**0 **to **59**), and **the SECOND function** yields a number as seconds (**0** to **59**). So, learn the following steps carefully to **Convert Hours **to **Decimal **in **Excel**.

**STEPS:**

- Firstly, choose the cell
**C5**to type the formula:

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

- Afterward, it’ll return the computed value after pressing
**Enter**. - Consequently, use the
**AutoFill**tool for filling the rest. - Thus, you’ll get the outcome as shown in the following picture.

**NOTE:** Here, we need to convert every part of **B5 **to **Hours**. That’s why we divide the **Minute Part **of **B5 **by **60 **(**1 Hour = 60 Minutes**) and the **Second Part **of **B5 **by **3600 **(**1 Hour = 3600 Seconds**). And, the **Hour Part **remains as it is.

- Then, select the range
**C5:C9**. - To get the
**Format Cells**dialog box, press**Ctrl**and**1 simultaneously.** - In the pop-out dialog box, choose
**Number Category**.

- Lastly, press
**OK**to return the correct**Time**in**Decimal format.**

**Read More: How to Convert Minutes to Decimal in Excel (3 Quick Ways)**

### 3. Use Excel CONVERT Function for Changing Hours to Decimal

Additionally, we can insert **the CONVERT function** in **Excel **to carry out our operation. This function can transform any number from one measurement system to another. It requires a number to convert and the measurement systems in its argument section. Hence, follow the below process for changing **Hours **to **Decimal**.

**STEPS:**

- Select cell
**C5**at first. - Now, type the formula:

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

- Next, press
**Enter**. You’ll see the precise value. - At last, use the
**AutoFill**to complete the list. - As a result, it’ll return all the
**Time**in**Hours**with decimal.

**Read More: How to Convert Hours and Minutes to Decimal in Excel (2 Cases)**

## Conclusion

Henceforth, you will be able to **Convert Hours **to **Decimal **in **Excel **following the above-described methods. Keep using them and let us know if you have more ways to do the task. Follow **the ExcelDemy** website for more articles like this. Don’t forget to drop comments, suggestions, or queries if you have any in the comment section below.

## Related Articles

**How to Reduce Decimals in Excel (10 Easy Methods)****Set Decimal Places in Excel with Formula (5 Effective Ways)****How to Remove Decimals in Excel with Rounding (10 Easy Methods)****Remove Decimals Without Rounding in Excel (4 Suitable Ways)****How to Change Decimals to Percentages in Excel (4 Easy Ways)****Excel 2 Decimal Places without Rounding (4 Efficient Ways)**