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
Name	Home Dept	Dept Worked In	Hours Worked
Garrett	Assembly	Injection
aNgela	Assembly	Paint
Travis	Injection	Assembly
Tony	Paint	Injection
Stephanie	PC	Paint
Tammy	Assembly	PC
Garrett	Paint	Assembly
aNgela	Assembly	Paint
Travis	PC	Assembly
Tony	Assembly	Injection
Stephanie	Assembly	Paint
Tammy	Assembly	PC
Garrett	Injection	Assembly
aNgela	Assembly	Paint
Travis	Injection	Assembly

<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>
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]1[/TD]

[TD="align: left"]Date[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]2[/TD]

[TD="align: left"]11/7/2017[/TD]
[TD="align: right"]4[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]3[/TD]

[TD="align: left"]11/1/2017[/TD]
[TD="align: right"]6[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]4[/TD]

[TD="align: left"]11/2/2017[/TD]
[TD="align: right"]8[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]5[/TD]

[TD="align: left"]11/10/2017[/TD]
[TD="align: right"]1[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]6[/TD]

[TD="align: left"]11/21/2017[/TD]
[TD="align: right"]8[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]7[/TD]

[TD="align: left"]11/1/2017[/TD]
[TD="align: right"]3[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]8[/TD]

[TD="align: left"]10/5/2017[/TD]
[TD="align: right"]8[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]9[/TD]

[TD="align: left"]9/4/2017[/TD]
[TD="align: right"]1[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]10[/TD]

[TD="align: left"]11/10/2017[/TD]
[TD="align: right"]8[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]11[/TD]

[TD="align: left"]11/21/2017[/TD]
[TD="align: right"]1[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]12[/TD]

[TD="align: left"]11/1/2017[/TD]
[TD="align: right"]8[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]13[/TD]

[TD="align: left"]10/5/2017[/TD]
[TD="align: right"]1[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]14[/TD]

[TD="align: left"]9/4/2017[/TD]
[TD="align: right"]8[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]15[/TD]

[TD="align: left"]11/10/2017[/TD]
[TD="align: right"]8[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]16[/TD]

[TD="align: left"]11/21/2017[/TD]
[TD="align: right"]1[/TD]

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.