To convert minutes into hours you must divide the desired number of minutes by 60, because each hour has 60 minutes.
Here are some examples:
How many hours are in 120 minutes?
120 / 60 = 2
We soon conclude that 120 minutes equals 2 hours.
But not all calculations are that simple, so let's make things more difficult:
How many hours are in 165 minutes?
The rule remains the same, 165 / 60 equals 2.75, and here we have an error, after all, there is no such thing as two hours and seventy-five minutes. This occurs because the result of the division is in decimals, so it is necessary to convert the decimals to minutes, you can even use our tool to convert decimals into minutes, access it by clicking here.
To convert the result in decimal to minutes we do: 0.75 * 60, thus resulting in 45, so we come to the conclusion that 165 minutes correspond to 02:45:00 (two hours and forty-five minutes).
To convert minutes into hours in excel you must divide the minutes by 60 and in the sequence by 24, I explain:
Let's say that in cell A1 you have the number of minutes and you want in cell A2 to show these minutes converted into hours, in cell A2 you should put: =(A1/60)/24
But be careful, the cell must be formatted in hours, otherwise Excel will display the result in decimals, and also pay attention to values greater than 23: 59, if the minutes you want to convert are greater than 24h, use custom formatting, just put it like this:[h]:mm;@
Minutes | Hours |
---|---|
60 minutes | 1 hour |
120 minutes | 2 hours |
180 minutes | 3 hours |
240 minutes | 4 hours |
300 minutes | 5 hours |
360 minutes | 6 hours |
420 minutes | 7 hours |
480 minutes | 8 hours |
540 minutes | 9 hours |
600 minutes | 10 hours |
1,200 minutes | 20 hours |
1,800 minutes | 30 hours |
2,400 minutes | 40 hours |
3,000 minutes | 50 hours |
3,600 minutes | 60 hours |