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.
In order to solve this problem, you would need to figure out how many hours and minutes are between 1:00 and 3:00 PM. The easiest way to do this is to âcount upâ from 1:00 to 3:00. In order to do this, you would think: from 1:00 PM to 2:00 PM is one hour. From 2:00 PM to 3:00 PM is one hour.nce you can read the hour and minutes, you may also be asked whether it is AM or PM. This is not read from the clock, but rather from what time of day it is. AM runs from midnight (12:00) to 11:59 (one minute before noon). At noon, it becomes PM, and PM goes from noon (12:00) to 11:59 (one minute before midnight).