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.
Functions and calculations to convert time to hours, minutes or seconds. In Microsoft Excel, to convert time to a total number of hours, minutes or seconds, you can use either: 1  Simple arithmetic calculations, i.e. multiply the time value by the number of hours, minutes or seconds in one day, or.ometimes, you may need to convert time into the format that reads something like  # days, # hours, # minutes and # seconds . A good thing is that you already know all the ingredients of the formula: 1  Extract days using the INT function; 2  Extract time units with HOUR, MINUTE and SECOND functions, and.