Weekly Hours of Employee

Hello:

I have excel file

Sheet1:
Column B : Date
Column C : Emp Name
Column F : Total Hours Worked

Sheet2:

Column A: Week# ( 1 to 52)
Column B: Workweek Start eg 1/2/2012
Column C : Workweek end eg 1/8/2012

I want total hours worked by each employee in a workweek defined (in Column B & C) in Column D, E, F where each employee will be listed.

Please refer to attached sheet.

Let me know if you have any questions.

Thanks for all the help i can get.

RM

Your file is 2003 ver, but I saw your Excel ver is 2010. SO try this with 2010 ver:
In D2:

=SUMIFS(Sheet1!$F$2:$F$409,Sheet1!$B$2:$B$409,">="&Sheet3!$B2,Sheet1!$B$2:$B$409,"<="&Sheet3!$C2,Sheet1!$C$2:$C$409,Sheet3!D$1)

Or with 2003:

=SUMPRODUCT((Sheet1!$B$2:$B$409>=Sheet3!$B2)*(Sheet1!$B$2:$B$409<=Sheet3!$C2)*(Sheet1!$C$2:$C$409=Sheet3!D$1),Sheet1!$F$2:$F$409)

Copy down and across.