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.
Sixty seconds make up a minute, while 60 minutes make up an hour. You can convert minutes into a percentage of an hour using basic division. For example, 30 minutes equals 50 percent of an hour, while 10 minutes equals about 17 percent of an hour.Calculating the percentage of an hour enables you to solve speed, time or distance problems, because speed is usually expressed in miles per hour.nstructions. Convert any seconds to a percentage of a minute by dividing by 60. For example, 14 minutes and 45 seconds equals 14.75 minutes, because 45/60 equals 0.75. Divide the number of minutes by 60, the total number of minutes in an hour.