afuente858
New Member
- Joined
- May 27, 2015
- Messages
- 3
I need help with a formula that will take lets say 220 hours and divide it across a duration of weeks with 33.5 working hours per week.
I want the formula to divide the block of hours (220 in "C18") across the duration (9 weeks in "F5"). Then Divide block of hours (100 in "C19"
SUM the range H18:P18 and determine if the SUM of the range is less than the block hours then divide again for the next cell untill the range is >= the block of hours then enter "0"
Duration in Weeks
9
7
Weeks | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |10|11|12|13|14|15|16|
220hrs |25|25 |25|25|25 |25|25 |25|20|0 |0 | 0 | 0 | 0 | 0| 0|
100hrs | 0 | 0 | 0 | 0| 0 |15|15 |15|15|15|15|10| 0 | 0 | 0| 0|
I want the formula to divide the block of hours (220 in "C18") across the duration (9 weeks in "F5"). Then Divide block of hours (100 in "C19"
SUM the range H18:P18 and determine if the SUM of the range is less than the block hours then divide again for the next cell untill the range is >= the block of hours then enter "0"
Duration in Weeks
9
7
Weeks | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |10|11|12|13|14|15|16|
220hrs |25|25 |25|25|25 |25|25 |25|20|0 |0 | 0 | 0 | 0 | 0| 0|
100hrs | 0 | 0 | 0 | 0| 0 |15|15 |15|15|15|15|10| 0 | 0 | 0| 0|