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.
To convert seconds into minutes you divide the total amount of seconds by 60: 455 seconds Ã· 60 = 7.583333 minutes. Then multiply the decimal part by 60 to get the leftover number of seconds: .583333 x 60 = 35 seconds.So in this example, 455 seconds = 7 minutes, 35 seconds.ith 2 pints in a quart, and 4 quarts in a gallon, there are 8 pints in a gallon. With 60 seconds in a minute, divide that 60 seconds by the 8 seconds it would take a gallon â¦ to pass. 60/8=7.5. 1 pint per second is 7.5 gallons per minute. Hank W.