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.
1440 the number of minutes in a day, 24*60. Excel represents time integer days and a fraction of a day; so 1 hr is 1/24, 1 min is 1/1440 and 1 second is 1/3600. I need an excel formula to convert quantity of minutes into days, hours and minutes.nswer. rich007a replied on July 8, 2011. If your minutes is in cell A1, use: =ROUNDDOWN(A1/1440,0) & days  & TEXT(TIME(,MOD(A1,1440),),[h]hrs mmmins). First we divide the minutes by 1440 (=24*60) minutes per day, and round it down to give us days.