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.
Date: 06/25/2003 at 10:28:31 From: Saurabh Mehta Subject: Converting Hours:Minutes (HH:MM) to Minutes in Excel Hi, I want to know if there is any easy method (i.e. any formula or a macro) available for converting Hours:Minutes (HH:MM) to Minutes in Excel. For example, 2:32 should be converted to 152. Date: 06/25/2003 at 12:00:56 From: Doctor Peterson Subject: Re: Converting Hours:Minutes (HH:MM) to Minutes in Excel Hi, Saurabh. You don't need any special formula or macro to do this; it's very easy.