# How to Convert Minutes to Decimal in Excel (3 Quick Ways)

Get FREE Advanced Excel Exercises with Solutions!

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.

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. Using Simple Multiplication to Convert Minutes to Decimal 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)

## 2. Inserting 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. Applying 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.

## Related Articles Mursalin Ibne Salehin

Hi there! This is Mursalin. I am currently working as a Team Leader at ExcelDemy. I am always motivated to gather knowledge from different sources and find solutions to problems in easier ways. I manage and help the writers to develop quality content in Excel and VBA-related topics.

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

• Reply 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! Advanced Excel Exercises with Solutions PDF  