In this tutorial, you will learn how to convert minutes to hours in Google Sheets.
How To Convert Minutes To Hours in Google Sheets
When working with data in Google Sheets, you might be required to convert a numerical value from minutes to hours.
This can be helpful if, for example, you are tracking the number of hours an employee worked, and they have logged their time in minutes.
We can represent the hours either as a decimal value or in the “hh:mm” format. For example, 90 minutes can either be written in hours as 1.5 or as 1:30.
In this guide, we will provide a few different methods you can use to convert minutes to hours in Google Sheets.
How To Write Minute Values As Hours in Google Sheets
Here’s how to write minute values as hours in Google Sheets.
Step 1
First, select the location you want to output the converted minutes.
In this example, we want to populate column C with the minute values in column B converted into hours.
Step 2
The simplest way to convert minutes to hours is by dividing the number of minutes by 60.
For example, 53 minutes is equivalent to 53/60 or about 0.88 hours.
Step 3
We can also use the CONVERT function to convert the minute values into hour values.
We simply need to specify three arguments: the value to convert, the starting unit of measurement, and the end unit you desire to convert to.
In this case, we’ll use the starting unit “min” and the end unit “hr”.
Step 4
If you want to convert minutes into hours and minutes, we must first convert our minutes into a fraction of a full day.
We can arrive at this result by dividing the minute values by 60 and dividing it further by 24. Alternatively, you can directly divide the number of minutes by 1440, which is simply 24 x 60.
Step 5
We’ll then need to convert the decimal values into a different number format.
Select the range of cells that you’ve divided.
Step 6
Select the option Format > Number > Custom date and time.
Step 7
Select the time format that shows the hour and minute separated by a colon. Click on Apply to proceed.
Step 8
Your selected range should now be converted into a minute and hour format.
For example, 80 minutes is now writtens as “1:20” or 1 hour and twenty minutes.
Step 9
We can also use the TEXT function to perform the number through a formula.
We’ll use the number format “hh:mm” to display just the hours and minutes from our day fraction.
Summary
This guide should be everything you need to convert minutes to hours in Google Sheets.
You may make a copy of this example spreadsheet to test it out on your own.