Convert weights into percentages:

t1 1 22.22% 2.222222222
t2 1.5 33.33% 3.333333333
t3 2 44.44% 4.444444444
4.5
This example is for three tasks only
Column A has the task name
Column B has your weights ( row #4 has the sum of the above)
Column C has the percents (=B1/$B$4 in C1)
Column D has the hour breakdown ( =10*C1 in D1)
--
Gary's Student


"jvan100" wrote:


Let's say I have 10 hours to accomplish 10 tasks. Having previously
accomplished each of these tasks I know some will take longer than
others. Let's say I want to weight them into three categories,
easiest receives a weight of 1, harder 1.5 and harder yet 2.5. What
Excel trick, or someones know how, would be used to spread my 10 hours
appropriately over the 10 tasks?


--
jvan100
------------------------------------------------------------------------
jvan100's Profile: http://www.excelforum.com/member.php...o&userid=29223
View this thread: http://www.excelforum.com/showthread...hreadid=489476