Code to sum columns between certain rows

[mlarobardi]

For the spreadsheet below I need code to determine what rows to add for the subtotal for each week for each person listed. The rows will vary each time

Smith, Joan
Week: WK1
								Visit
		Date	OMR	Pay Item		UM	Rate	Start	Finish	Time	Subtotal
		10/25/13	GA	RG		H	0.00			35	0.00
Totals for WK1: 0 Visit / 2 Admin			35.17	0.00
Week: WK2
								Visit
		Date	OMR	Pay Item		UM	Rate	Start	Finish	Time	Subtotal
		11/1/13	GA	F		H	0.00			8	0.00
		11/1/13	GA	RG		H	0.00			30.5	0.00
Totals for WK2: 0 Visit / 2 Admin			38.50	0.00
Totals for Smith, Joan - 0 Visit / 4 Admin		73.67	0.00
Hancock, John
Week: WK1
								Visit
		Date	OMR	Pay Item		UM	Rate	Start	Finish	Time	Subtotal
		10/25/13	GA	RG		H	1.00			40	40.00
Totals for WK1: 0 Visit / 1 Admin			40.00	40.00
Week: WK2
								Visit
		Date	OMR	Pay Item		UM	Rate	Start	Finish	Time	Subtotal
		11/1/13	GA	RG		H	1.00			41	41.00
Totals for WK2: 0 Visit / 2 Admin			46.00	41.00
Totals for Hancock, John: 0 Visit / 3 Admin		86.00	81.00
Harris, Lynn
Week: WK1
								Visit
		Date	OMR	Pay Item		UM	Rate	Start	Finish	Time	Subtotal
		10/21/13	SN	RNPDNX		H	30.00	06:00	07:00	1	30.00
		10/21/13	SN	RNPDNX		H	30.00	06:00	07:00	1	30.00
		10/21/13	SN	RNPDNX		H	30.00	07:00	12:15	5.25	157.50
		10/21/13	SN	RNPDNX		H	30.00	07:00	12:15	5.25	157.50
		10/21/13	SN	RNPDN		H	20.00	12:15	15:45	3.5	70.00
		10/21/13	SN	RNPDNX		H	30.00	15:45	19:00	3.25	97.50
		10/21/13	SN	RNPDNX		H	30.00	15:45	19:00	3.25	97.50
		10/24/13	SN	RN AM		H	23.16	08:00	16:10	8.17	189.14
		10/25/13	SN	RN AM		H	23.16	08:00	16:15	8.25	191.07
		10/25/13	SN	RNPDNX		H	30.00	16:15	23:00	6.75	202.50
		10/25/13	SN	RNPDNX		H	30.00	16:15	23:00	6.75	202.50
Totals for WK1: 11 Visits			52.42	1,425.21
Week: WK2
								Visit
		Date	OMR	Pay Item		UM	Rate	Start	Finish	Time	Subtotal
		11/1/13	SN	RNPDNX		H	30.00	07:00	16:00	9	270.00
		11/1/13	SN	RNPDNX		H	30.00	07:00	16:00	9	270.00
		10/28/13	SN	RN AM		H	23.16	08:00	14:00	6	138.96
		10/31/13	SN	RN AM		H	23.16	08:00	16:00	8	185.28
Totals for WK2: 4 Visits			32.00	864.24
Totals for Lynn Harrisl: 15 Visits		84.42	2,289.45

<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[mlarobardi]

I can't figure out how to edit this post. What I need to do is calculate the subtotal (Time & Subtotal columns) for each week for each employee then then total week 1 & 2. The current totals are not correct for all employees because I have deleted some lines from the original export.