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.
Instructions. 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.For example, convert 14.75 minutes to a percentage by dividing 14.75 by 60, which equals about 0.246, or 24.6 percent.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.