# How to Convert Minutes to Decimal values in Excel – 3 Methods

The sample dataset is in Time Format. To convert time into minutes and then to decimal format:

## Method 1 – Using a Simple Multiplication to Convert Minutes to Decimal Values in Excel

STEPS:

• Select C5 and enter the formula:
`=B5*24*60`

• Press Enter to see the result.

• Double-click the Fill Handle to see the result in the rest of the cells.

• Select the cells that contain minutes. Here, C5:C7.

• Press Ctrl + 1 to open the Format CellsÂ window.
• Select the NumberÂ tab.
• Select Number in CategoryÂ and click OK.

• This is the output.

• To show minutes without the fraction, use the formula below:
`=INT(B5*24*60)`

The INT function shows the whole number.

• Press Enter to see the result.
• Drag down the Fill Handle to see the result in the rest of the cells.

Note: To show time in hours, use the formula below:

`=B5*24`

To show it in seconds, use:

`=B5*24*60*60`

Read More: How to Convert Minutes to Days in Excel

## Method 2 – Using the Excel Time Functions to Change Minutes to Decimal Values

Use the HOUR, MINUTE, and SECOND functions.

STEPS:

• Select C5 and enter the formula:
`=HOUR(B5)*60+MINUTE(B5)+SECOND(B5)/60`

The HOUR function extracts the hour part inÂ B5 and converts it to minutes. The MINUTE function extracts the minute part. The SECOND function converts the seconds into minutes.

• Press Enter to see time in minutes.

• Drag down the Fill Handle to see the result in the rest of the cells.

• Select C5:C7.

• Press Ctrl + 1 to open the Format CellsÂ window.
• Select Number in Category and click OK.

This is the output.

Note: To see time in hours, use the formula below:

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

And in seconds, use:

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

## Method 3 – Applying the CONVERT Function to Transform Minutes to Decimal values in Excel

Use the CONVERT function. It changes a number from one measurement system to another.

STEPS:

• Select C5 and enter the formula:
`=CONVERT(B5,"day","mn")`

• Press Enter to see the result.

• Drag down the Fill Handle to see the result in the rest of the cells.

Note: To show time in hours, use the formula below:

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

And in seconds, use:

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

## Related Articles

Get FREE Advanced Excel Exercises with Solutions!
Mursalin Ibne Salehin

Mursalin Ibne Salehin holds a BSc in Electrical and Electronics Engineering from Bangladesh University of Engineering and Technology. Over the past 2 years, he has actively contributed to the ExcelDemy project, where he authored over 150 articles. He has also led a team with content development works. Currently, he is working as a Reviewer in the ExcelDemy Project. He likes using and learning about Microsoft Office, especially Excel. He is interested in data analysis with Excel, machine learning,... Read Full Bio