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 decimals to time in the standard hour: minute format, use the function TEXT(value, format). The value needs to be divided by 24, since there are 24 hours in day. Use h:mm as the format. The calculation returns the time since 12:00 a.m.The value can reference a spreadsheet cell.onvert Serial Number to Time. To convert a serial number, or decimal fraction of a day, to hours, minutes and seconds use HOUR(serial number), MINUTE(serial number) and SECOND(serial number). Each formula returns only the portion of time requested. Serial numbers can also be a text string such as 6:30 p.m.).