Weighted averages are used often in investing. It's basically how we measure the performance of our respective portfolios. In fact, the S&P 500 index is the weighted average performance of the 500 largest companies on the major U.S. stock exchanges by market capitalization.
To convert minutes in decimal format to a proper Excel time, just divide by 1440. For example, if you have a number that represents minutes in cell A1, use: If A1 contains the number 360 (representing 360 minutes) then the result will be 360/1440 = .25, since 360 minutes = 6 hours = 1/4 day.To see the result formatted in a normal time format, you'll need to change the number format to a time format.or example, if you have a number that represents minutes in cell A1, use: If A1 contains the number 360 (representing 360 minutes) then the result will be 360/1440 = .25, since 360 minutes = 6 hours = 1/4 day. To see the result formatted in a normal time format, you'll need to change the number format to a time format.
This gives you the total time in (just) hours. 1  For example, let's say that we need to convert 3 hours and 9 minutes to just hours. 2  To do this, all we need to do is figure out how many hours 9 minutes is, then add it to 3 hours. 3  In other words, 9 minutes Ã 1 hour/60 minutes = 0.15 hours + 3 hours = 3.15 hours.ultiply 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. 1  In our example, multiplying 2.5 hours Ã 60 minutes/1 hour = 150 minutes â exactly what we started with.