In this article, we will learn to **convert minutes to decimal in Excel**. To do so, we need to convert a time to minutes first. Then, convert the minutes to decimal. Here, we will demonstrate **3 **easy methods. Using these methods, you will be able to convert minutes to decimal easily. So, without further delay, letâ€™s start the discussion.

**Table of Contents**hide

## Download Practice Book

Download the practice book here.

## 3 Quick Ways to Convert Minutes to Decimal in Excel

To explain the methods, we will use a dataset that contains some time in **Time Format**. We will convert these times into minutes and then to decimal format.

### 1. Convert Minutes to Decimal Using Simple Multiplication in Excel

We can use simple multiplication to convert minutes to decimals in Excel. This process is simple and easy to understand. Letâ€™s follow the steps below to learn more.

**STEPS:**

- First of all, select
**Cell C5**and type the formula:

`=B5*24*60`

- Secondly, press
**Enter**to see the result.

- Thirdly, double-click the
**Fill Handle**to autofill the rest of the cells.

- In the following step, select the cells that contain the minutes. We have selected
**Cell C5**to**C7**.

- After that, press
**Ctrl**+**1**to open the**Format CellsÂ**window. - In the
**Format Cells**window, select the**NumberÂ**tab. - Then, select
**Number**in the**Category**section and click**OK**to proceed.

- After clicking
**OK**, you will see results like the picture below.

- To show minutes without the fraction, type the formula below:

`=INT(B5*24*60)`

Here, we have used **the INT function **to express the whole number.

- In the end, press
**Enter**and use the**Fill Handle**to see all results.

**Note: **To express time in hours, use the formula below:

`=B5*24`

And to express in seconds, you can use:

`=B5*24*60*60`

**Read More: How to Convert Hours to Decimal in Excel (3 Easy Methods)**

**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. Insert Excel Time Functions to Change Minutes to Decimal

Another way to change minutes to decimals in Excel is to insert the time functions. In Excel, the **HOUR**, **MINUTE**, and **SECOND **are the time functions. Again, we will use the same dataset. So, without any delay, letâ€™s jump to the steps.

**STEPS:**

- In the beginning, select
**Cell C5**and type the formula:

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

In this formula, the **HOUR **function extracts the hour part of **Cell B5 **and converts it to minutes. Also, the **MINUTE **function extracts the minute part. And the **SECOND **function converts the seconds into minutes.

- After that, press
**Enter**to see the time in minutes.

- Now, use the
**Fill Handle**to see results in the rest of the cells.

- Next, select
**Cells C5**to**C7**.

- In the following step, press
**Ctrl**+**1**on the keyboard to open the**Format CellsÂ**window. - In the
**Format Cells**window, select**Number**in the**Category**section and click**OK**.

- Finally, you will see results like the screenshot below.

**Note: **To express time in hours, use the formula below:

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

And to express in seconds, you can use:

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

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

### 3. Apply CONVERT Function to Transform Minutes to Decimal in Excel

The quickest way to transform minutes into decimals in Excel is to use **the CONVERT function**. The **CONVERT **function changes a number from one measurement system to another. Once again, we will use the previous dataset. So, letâ€™s observe the steps below to know more about the method.

**STEPS:**

- Firstly, select
**Cell C5**and type the formula:

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

- After that, press
**Enter**to see the result.

- Finally, use the
**Fill Handle**to see results in all other cells.

**Note: **To express time in hours, use the formula below:

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

And to express in seconds, you can use:

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

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

## Things to Remember

In Excel, you must be aware of cell formats while working with times. Because different cell formats produce different results in the case of time.

## Conclusion

In this article, we have demonstrated **3 **easy methods to **Convert Minutes to Decimal in Excel**. Here, we have used practical datasets to explain the process. I hope these methods will help you to perform your tasks easily. Furthermore, we have also added the practice book at the beginning of the article. To test your skills, you can download it to exercise. Last of all, if you have any suggestions or queries, feel free to ask 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)**

This wasn’t helpful at all. I want to convert minutes to decimal number and this didn’t help at all.

Hello, Bimen!

Sorry to hear that you are facing problems converting minutes to decimal numbers. You can send your excel file to [email protected] and we will try to give a solution to your problem.

Thanks!