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.
Convert number of minutes to hours and minutes. I am trying to create a spreadsheet showing the time it takes to walk various distances at various speeds. I want the result to be shown as hours and minutes. I can get hours and decimal portions of hours, 90 minutes as 1.5 hours.I want the result in hours and minutes, 90 minues as 1 hr. 30 minutes--1:30.1,33226762955019E-14 minutes. I Evaluated the formula in Excel 2007 and the result is correct in the Evaluate formula but it still gives me -1,33226762955019E-14 in the cell. 1  Convert number of minutes to hours and minutes.xlsâ (18.0 KB, 431 views) Download.