I've looked at this until my eyes are crossed and I'm sure someone out there can easily figure this out.
I need a formula to spread project time hours across weekdays to equal 8 hours/day and 40 hours/week. I'm looking for a formula to copy from C2:G10, please.
<tbody>
</tbody>
Thank you in advance!!!
I need a formula to spread project time hours across weekdays to equal 8 hours/day and 40 hours/week. I'm looking for a formula to copy from C2:G10, please.
A | B | C | D | E | F | G | |
1 | Project Number | Project Hours | Monday | Tuesday | Wednesday | Thursday | Friday |
2 | 1001 | 7 | 7 | ||||
3 | 1002 | 5 | 1 | 4 | |||
4 | 1003 | 6 | 4 | 2 | |||
5 | 1004 | 6 | 6 | ||||
6 | 1005 | 3 | 3 | ||||
7 | 1006 | 1 | 1 | ||||
8 | 1007 | 9 | 4 | 5 | |||
9 | 1008 | 2 | 2 | ||||
10 | 1009 | 1 | 1 | ||||
11 | Total Hours | 40 | 8 | 8 | 8 | 8 | 8 |
<tbody>
</tbody>
Thank you in advance!!!