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.
=HOUR(A2) + MINUTE(A2)/60 + SECOND(A2)/360. For example, if a cell contains the time value of 6:30 AM, both formulas will return 6.5 because 6 hours and 30 minutes is equal to 6.5 hours. To get the number of compete hours, wrap the above formula in the INT function to cast away the fractional part: =INT(A2*24).ou will find a variety of formulas to change time to hours, minutes or seconds as well as convert text to time and vice versa. Because Microsoft Excel uses a numeric system to store times, you can easily turn hours, minutes and seconds into numbers that you can use in other calculations.