Excel is based on a system that helps in storing time values and you can convert them into hours, minutes, and seconds. These values can be adjusted in terms of numbers to use for calculations. Basically, you can use two methods to convert time values into decimals – one way is to change the cell format and the other way is to use arithmetic calculations or time functions including HOUR, MINUTE, and SECOND.
In this tutorial, you will get to know how to convert time to minutes in Excel:
How to Convert Hours and Minutes to Minutes with Multiplication?
The first method uses the multiplication of time durations to convert them into other values. Below you can find the relationship between time units:
1 Day = 24 Hours = 24 * 60 or 1440 Minute
Let’s understand the method with simple steps:
- First, you need to edit the C5:C11 format from General to Number.
- Choose C5:C11.
- Open the Home tab.
- Now, choose the icon you can see in the image.
- A dialog box of Format Cells will pop up.
- From this box, choose the Number option.
- Change the decimal places to 0.
- Now, click OK.
Click on the C5 and enter the below-given formula:
=B5*1440
- Now, press ENTER key.
- Use Fill Handle to Auto Fill C11.
That’s it!
This is how to convert hours to minutes in Excel by simply following the above steps.
Use the CONVERT Function to convert Time to Minutes in Excel:
With the help of the CONVERT function, you can easily manage to convert the time > hours values. Here is the formula:
=CONVERT(A2, “day”, “hr”)
The above formula helps you in understanding how to convert time into minutes in Excel.
Use HOUR, MINUTE, and SECOND Functions to Convert Time to Minutes in Excel:
Another formula is there to help you sort the problem of converting time to minutes in Excel. This formula is a bit complicated in that you need to drag the time units with the help of HOUR, MINUTE, and SECOND functions. Once these functions are applied, you need to divide the minute values by 60 and seconds by 3600 and then add up the results:
=HOUR (A2) + MINUTE(A2)/60 + SECOND (A2)/3600
How to Combine HOUR and MINUTE Functions to Convert Hours and Minutes to Minutes?
In this simple process, you will use the HOUR and MINUTE functions to convert time durations. Below are easy-to-follow steps:
- First, you need to change the format of C5:C11 to Number. You can use the same method as above to change the format.
- Go to the C5 and enter the following formula:
=HOUR(B5)*60+MINUTE(B5)
- Press ENTER key and your results will be there.
- Use the Fill Handle option to AutoFill the C11.
This is how to convert hours and minutes to minutes in Excel by simply following the above steps.
How to Convert Minutes to Hours in Excel
Apart from the above methods, you can convert minutes to hours in Excel as well. This super effective procedure uses the TIME function to convert minutes to hours in Excel.
- First, you need to change the format of C5:C11.
- For this, select C5:C11 and open the Home tab.
- Now, choose the icon given in the image.
- A dialog box of “Format Cells” pops up.
- Click on the Custom option from the box.
- Enter the format h, “hour”, mm, “minute”.
- Press OK.
- Now, go back to the C5 and enter the formula given below:
=TIME(0, B5, 0)
- Press ENTER key and your results will be in front of you.
- Use the Fill Handle option to AutoFill the C5:C11.
Things to Consider:
As already mentioned, the relationship between time units is:
1 Day = 24 Hours = 24 * 60 or 1440 Minutes
Summary:
This post explains how to convert time to minutes in Excel. Hopefully, it helps you in understanding this phenomenon. You can try all the above-mentioned methods without any hesitation.
