Distribute value across cells

[ctlcdm]

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.

	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!!!

 

[Dave Patton]

Excel 2010
	A	B	C	D	E	F	G	H
1	Project Number	Project Hours		Monday	Tuesday	Wednesday	Thursday	Friday
2
3	1001	7		7
4	1002	5		1	4
5	1003	6			4	2
6	1004	6				6
7	1005	3					3
8	1006	1					1
9	1007	9					4	5
10	1008	2						2
11	1009	1						1
12	Total Hours	40		8	8	8	8	8
13
1e

Cell Formulas
Range	Formula
D3	=MIN($B3,8,8-SUM(D$2:D2),$B3-SUM($C3:C3))

N.B.
There is a blank row 2 and a blank Column C
Copy the formula in D3 across and down.

 

[ctlcdm]

Dave - you are an excel genius and I greatly appreciate your help!!!

 

[Dave Patton]

Thanks for the feedback.