Allocating values in proportion to a known value

  • Thread starter Thread starter ltclgc
  • Start date Start date
L

ltclgc

When reporting my time worked I have several funding streams I mus
charge to. If I take sick, annual, or a paid holiday I must allocat
the leave hours proportionate to the time I worked for that week. Fo
example:

I work 25 of 35 hours for fund #1 = 71.5% of total time
I work 7 of 35 hours for fund #2 = 20% of total time
I work 3 of 35 hours for fund #3 = 8.5% of total time

I take 4 hours annual leave and 1 hour sick leave for a tota
possible work week of 40 hours

I need to allocate the leave proportionately (the same percentage) t
each of the funds I charged actual work time to.

Does anyone out there have the Excel savy to create what I need. M
skills are limited
 
Does anyone out there have the Excel savy to create what I need. My
skills are limited.
Click to expand...

Create one cell that contains the total number of hours.

Create one cell for each fund that contains the percentage of hours worked
on each fund.

Then create one cell for each fund that contains the product of the total
leave hours with the percentage. This gives you the total number of leave
hours allocated to each fund.

P.S. 25 of 35 hours is 71.4% not 71.5%; 3 of 35 hours is 8.6%
 
Back
Top