Have you ever wanted to Convert minutes to hours or convert minutes to seconds? This article has no connection with converting minutes to hours, but it does talk about how to convert minutes in excel. Also in this article, I give you formulas for how to convert minutes into seconds!
I’ve spent a lot of time converting minutes to hours to minutes to seconds and now I want to show you how. I’m going to show you 4 ways and then we’re going to look at making it easy to convert minutes/seconds/hours into smaller units. This would mean that we can estimate the amount or number of units we need in order to execute tasks based on the amount we need and the amount (or length) of time we need to perform said task(s).
- Start with your number of minutes. You can do this a few different ways. For example, if you’re working on paper, you might write down the number of minutes and label it with the word “minutes.” If you’re using a calculator, just type in the number.
- As an example, let’s say that we want to find out how many hours a 150 minute movie will be. In this case, we’ll start by writing down 150 minutes. In the next few steps, we’ll solve!
- 2 Multiply by “1 hour/60 minutes.“ Next, write (or type) a multiplication sign (×), then the fraction 1 hour/60 minutes. This fraction shows how many minutes are in an hour (60). When we multiply, we’ll end up with the correct units, too (since the two “minutes”) cancel out.[2]
- This is the same as dividing by 60/1, or 60. If you need help dividing and multiplying fractions, see WikiHow’s help article on this topic.
- 3 Solve. Now you just need to do the math. The answer you get will be the number of hours you’re looking for.
- In our example, 150 minutes × 1 hour/60 minutes = 2.5 hours, or 2 1/2 hours. This is the same as 150 divided by 60 or 150/60.
- 4 Multiply by 60 to get back to minutes. Taking an hours measurement and multiplying it by 60 will get you minutes again. Technically, you’re multiplying by 60 minutes/1 hour so that the two “hours” cancel properly.
- In our example, multiplying 2.5 hours × 60 minutes/1 hour = 150 minutes — exactly what we started with.
- 5 If your measurement is in hours and minutes, just deal with the minutes. Sometimes, time measurements are given like this: x hours y minutes. In this case, you can just convert the “y minutes” portion to hours, then add it to the “x hours” portion. This gives you the total time in (just) hours.
- For example, let’s say that we need to convert 3 hours and 9 minutes to just hours. To do this, all we need to do is figure out how many hours 9 minutes is, then add it to 3 hours. In other words, 9 minutes × 1 hour/60 minutes = 0.15 hours + 3 hours = 3.15 hours.
Table of Contents
Method 2 Converting to Hours and Minutes
- 1 Convert your minutes to hours as normal. Up until now, we’ve only discussed how to get answers written in hours. However, since time is often written as hours and minutes, it’s nice to know how to do this too. Luckily, this is easy. To start, just convert your minute measurement into hours like you learned in the section above.[3]
- Let’s follow along with an example problem. If we want to convert 260 minutes to hours, we would multiply 260 minutes × 1 hour/60 minutes = 4.33 hours or 4 1/3 hours.
- 2 Multiply the decimal or fraction by 60. Unless your minutes converted perfectly to hours, you’ll have an answer with a decimal or fraction in it. You want to multiply this part by 60. Leave the whole number alone — we’re only dealing with the “extra” decimal or fraction part. Label your answer as “minutes”.[4]
- In our example, we would multiply just the “.33” by 60. 0.33 × 60 = 20 minutes.
- If we use a fraction instead of 0.33, we get the same answer. 1/3 × 60 = 20 minutes.
- 3 Write your answer as hours and minutes. The answer you just got is the “minutes” part of your final answer. You already know the “hours” part — it’s the whole number you got when you first converted. Write your answer like this: x hours, y minutes.
- In our example, our first answer was 4.33 hours. We just found out that the “.33” part is equal to 20 minutes, so we would write our answer as 4 hours 20 minutes.
Solved Examples on Conversion of Minutes into Hours:
1. Convert 45 minutes into hours.
We know, 60 minutes = 1 hour
or, 1 minute = 1/60 hour
Therefore, 45 minutes = 45/60 hour = ¾ hour.
2. Convert 25 minutes into hours.
We know, 60 minutes = 1 hour
or, 1 minute = 1/60 hour
Therefore, 25 minutes = 25/60 hour = 5/12 hour.
3. Convert 15 minutes into hours.
We know, 60 minutes = 1 hour
or, 1 minute = 1/60 hour
Therefore, 15 minutes = 15/60 hour = ¼ hour.
4. Convert 54 minutes into hours.
We know, 60 minutes = 1 hour
or, 1 minute = 1/60 hour
Therefore, 54 minutes = 54/60 hour = 9/10 hour
Minutes
The minute is a period of time equal to 1/60 of an hour or 60 seconds.
The minute is an SI accepted unit for time for use with the metric system. Minutes can be abbreviated as min; for example, 1 minute can be written as 1 min.
Hours
The hour is a period of time equal to 1/24 of a day or 60 minutes.
The hour is an SI accepted unit for time for use with the metric system. Hours can be abbreviated as hr; for example, 1 hour can be written as 1 hr.
Minute to Hour Conversion Table
| Minutes | Hours | Hours, Minutes & Seconds |
|---|---|---|
| 1 min | 0.016667 hr | 0 hr 1 min |
| 10 min | 0.166667 hr | 0 hr 10 min |
| 20 min | 0.333333 hr | 0 hr 20 min |
| 30 min | 0.5 hr | 0 hr 30 min |
| 40 min | 0.666667 hr | 0 hr 40 min |
| 50 min | 0.833333 hr | 0 hr 50 min |
| 60 min | 1 hr | 1 hr |
| 70 min | 1.1667 hr | 1 hr 10 min |
| 80 min | 1.3333 hr | 1 hr 20 min |
| 90 min | 1.5 hr | 1 hr 30 min |
| 100 min | 1.6667 hr | 1 hr 40 min |
| 200 min | 3.3333 hr | 3 hr 20 min |
| 300 min | 5 hr | 5 hr |
| 400 min | 6.6667 hr | 6 hr 40 min |
| 500 min | 8.3333 hr | 8 hr 20 min |
| 600 min | 10 hr | 10 hr |
| 700 min | 11.67 hr | 11 hr 40 min |
| 800 min | 13.33 hr | 13 hr 20 min |
| 900 min | 15 hr | 15 hr |
| 1,000 min | 16.67 hr | 16 hr 40 min |
| 1,440 min | 24 hr | 24 hr |
| 2,000 min | 33.33 hr | 33 hr 20 min |
| 3,000 min | 50 hr | 50 hr |
| 4,000 min | 66.67 hr | 66 hr 40 min |
| 5,000 min | 83.33 hr | 83 hr 20 min |
| 6,000 min | 100 hr | 100 hr |
| 7,000 min | 116.67 hr | 116 hr 40 min |
| 8,000 min | 133.33 hr | 133 hr 20 min |
| 9,000 min | 150 hr | 150 hr |
| 10,000 min | 166.67 hr | 166 hr 40 min |
How to Convert Minutes to Hours in Excel
It is very simple to automatically convert minutes to hours in Excel. We can use simple math to achieve the result we want. This step by step tutorial will assist all levels of Excel users in converting minutes to hours.
Final Formula: =B3/60
Converting Minutes to Hours
In order to convert minutes to hours, we simply divide the number of minutes by 60 because there are 60 minutes in every hour.
- We enter minutes in cell A3
- In cell B3, enter this formula
=A3/60
Figure 1 – Applying division formula
We can see in this Example, the formula in B3 returns “4” because 240 divided by 60 is equal to 4. Thus, 240 minutes is equal to 4 hours.
Conclusion
In mathematics, there are many conversion calculations that need to be performed constantly. They serve a variety of purposes and include: Data comparison and sorting. Scientific analysis and experiments. Time measurements and intervals. And, like any other conversions, minutes to seconds math can make it easier to do these kinds of tasks!