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.
How to convert decimal minutes to time format: Convert 78.6 minutes to hh:mm:ss. 1  78.6 minutes can be converted to hours by dividing 78.6 minutes / 60 minutes/hour = 1.31 hours. 2  1.31 hours can be broken down to 1 hour plus 0.31 hours - 1 hour. 3  0.31 hours * 60 minutes/hour = 18.6 minutes - 18 minutes.onvert 3.2 days to hh:mm:ss. 1  3.2 days can be converted to hours by multiplying 3.2 days * 24 hours/day = 76.8 hours. 2  76.8 hours can be broken down to 76 hours plus 0.8 hours - 76 hours. 3  0.8 hours * 60 minutes/hour = 48 minutes - 48 minutes.