This tutorial will demonstrate how to convert decimal to time in excel using formula. Excel by default stores time in decimal format. But we need to convert it into days, hours, minutes, or seconds for our needs. Decimal time is commonly used in excel to track the record of a person’s time spent on a project. But converting decimal to time is useful to calculate it easily. So, we need to learn to convert decimal to time excel formula.

**Table of Contents**hide

## Download Practice Workbook

You can download the practice workbook from here.

## 3 Easy Methods to Convert Decimal to Time in Excel Using Formula

In this case, our goal is to convert decimal to time in Excel using a formula in **3** ways. To do that, we’ll use a sample dataset overview as an example in Excel to understand easily. In **Column B **we have **Decimal** and in **column C** we have **Days, Hours, and Minutes**. If you follow the methods correctly, you should learn how to convert decimal to the time excel formula yourself.

### 1. Using TEXT Function

**The** **TEXT Function** is mainly used to convert a numeric value to a particular formula for many purposes. In this case, we aim to convert decimal to time by using an excel formula with this function. We will describe the steps of this method below.

**Steps:**

- First, in the
**C5**cell insert the following formula.

`=TEXT(B5/24, " d\d h\h m\m")`

- After pressing the
**Enter**button, you will get the result for the cell and then use the**Fill Handle**to apply the formula to all the desired cells.

- Finally, you will get the desired result.

**Read More:** **How to Convert Fraction into Hours and Minutes in Excel (3 Ways)**

### 2. Combining INT and TEXT Functions

Here we will convert decimal to time in excel by using a formula. To create the formula we will combine **the INT Function **and **the TEXT function**. The **INT Function** is mainly used to return the integer part of a decimal number. So, combining both functions can be very helpful in this case. Let’s describe the method with easy steps below in order.

**Steps:**

- To begin with, in the
**C5**cell insert the following formula.

`=INT(B5/24) & "days" & TEXT(B5/24, " h\h m\m")`

- In addition, press the
**Enter**button, and you will get the result for the cell, and then use the**Fill Handle**to apply the formula to all the desired cells.

- Finally, you will get the desired result.

**🔎 ****How Does the Formula Work?**

**INT(B5/24) & “days”:**In the first portion, it represents the decimal values and converts the values into days.**TEXT(B5/24, ” h\h m\m”):**This portion takes the values in decimal and converts them into hours and minutes.

**Read More:** **Convert Number to Time hhmmss in Excel (2 Suitable Ways)**

### 3. Manually Converting Decimal to Minutes and Seconds

In this case, our goal is to convert decimal to time in excel manually by using a multiplication formula. This is the easiest option to create in an excel sheet. Let’s describe the steps of this method below.

**Steps:**

- Firstly, in the
**C5**cell insert the following formula.

`=B5*24*60`

- Secondly, if you press the
**Enter**button, you will get the result for the cell and then use the**Fill Handle**to apply the formula to all the desired cells.

- Thirdly, you will get the desired result.

- Fourthly, in the
**D5**cell insert the following formula.

`=B5*24*60*60`

- After pressing the
**Enter**button, you will get the result for the cell and then use the**Fill Handle**to apply the formula to all the desired cells.

- Lastly, you will get the final result.

**Read More:** **Convert Number to Hours and Minutes in Excel (2 Easy Methods)**

## Applying Custom Format to Convert Decimal to Time in Excel

Excel has a **custom format** to transform decimals into time. Now, we aim to apply the **custom format **to fulfill our goal. The steps of this method are described below.

**Steps:**

- To begin with, select the selected data(in this case
**Column B**) and press**Ctrl+C**. - Next, press
**Ctrl+V**in**Column C.**

- In addition, select the cells of
**Column C**and press**Ctrl+1**.

- Furthermore, the Format Cells dialog box will open on the screen.
- Then, go to
**Number > Time > Type > Select desired type > OK**.

- Finally, you will get the desired result.

**Read More:** **Format Hours and Minutes Not Time in Excel (with Quick Steps)**

## How to Change Time to Decimal in Excel

At this point, we aim to change time to decimal by using **the CONVERT Function**. Recording time is helpful in tracking attendance easily. But converting it into decimal helps to learn how much time a person has spent to complete the project. By that, one can easily understand the dedication level of another person. The steps of this method are described below.

**Steps:**

- At first, in the
**C5**cell insert the following formula.

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

- Second, click the
**Enter**button to get the result for the cell, and then use the**Fill Handle**to apply the formula to all the desired cells.

- Last, you will get the desired result.

## Things to Remember

- Among all the methods, using the
**TEXT Function**is the easiest to create and most efficient way to use it in all situations. - If only you don’t want to use any formula, then you can use the
**Custom Format**. - No matter which method you have used, just learn it well enough so that you can understand its formula and final output.

## Conclusion

Henceforth, follow the above-described methods. Thus, you can convert decimal to the time using an excel formula. 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.