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.
Adding Time on a Calculator Adding time on a calculator without converting the minutes to hundredths is inaccurate. Units of time are calculated as 60 minutes equals 1 hour, but a calculator uses units of 100. For example, if an employee worked 9 hours and 30 minutes on one day and 8 hours and 45 minutes on the day, the time card would display 9:30 for day 1 and 8:45 for day 2. If you were to add these without converting on a calculator, you would get 17.75 hours which is 17 hours and 45 minutes. 9.30 8.45 17.75 = 17 hours and 45 minutes. This is inaccurate. When you change the minutes to 100ths using the conversion chart below, the 9:30 becomes 9.50 and the 8:45 becomes 8.75.