Summarize Data by Person, Location, and, Week

[south0085]

Our HR department wants me to create an easy way for them to summarize the following data:

Sheet1

	A	B	C	D	E
1	Name	Home Dept	Dept Worked In	Date	Hours Worked
2	Garrett	Assembly	Injection	11/7/2017	4
3	aNgela	Assembly	Paint	11/1/2017	6
4	Travis	Injection	Assembly	11/2/2017	8
5	Tony	Paint	Injection	11/10/2017	1
6	Stephanie	PC	Paint	11/21/2017	8
7	Tammy	Assembly	PC	11/1/2017	3
8	Garrett	Paint	Assembly	10/5/2017	8
9	aNgela	Assembly	Paint	9/4/2017	1
10	Travis	PC	Assembly	11/10/2017	8
11	Tony	Assembly	Injection	11/21/2017	1
12	Stephanie	Assembly	Paint	11/1/2017	8
13	Tammy	Assembly	PC	10/5/2017	1
14	Garrett	Injection	Assembly	9/4/2017	8
15	aNgela	Assembly	Paint	11/10/2017	8
16	Travis	Injection	Assembly	11/21/2017	1

<colgroup><col style="width: 30px; font-weight: bold;"><col style="width: 138px;"><col style="width: 138px;"><col style="width: 109px;"><col style="width: 74px;"><col style="width: 89px;"></colgroup>

Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4

They want to be able to summarize it by week. (Monday thru Saturday)

A summary would look like this:

Excel Workbook
	A	B	C	D
25	Home Dept	Dept Worked In	Hours Total	Week
26	Assembly	Injection	15	11/6-11/11
27	Injection	PC	21	11/6-11/12
28	HR	Paint	16	11/6-11/13
29	Paint	Assembly	18	11/6-11/14
Sheet1

This is completely just an example. I didn't even add up the numbers correct. I just made something up. But you get what I'm trying to do. But they want the ability to choose any week of the year. Week#1, Week#2, Week#34, etc.

Is there an easy way to do this. Keep in mind that the person using this sheet may be a novice excel user.

Thank you!

 

[south0085]

test - this post is not showing up on the forum list. Trying to figure out why. Sorry if you see this test.