Formula for Calculating Total Time

Good Day,

I found an excel tool on-line and kind of formatted it to suit an analysis that we want to to asses the time it takes to do specific task. That part was done but now my manager wants me to be able to pull the weekly totals from the productivity analysis workbook to the other weekly analysis workbook. Now I am not that good in excel and was wondering if there is a formula that can be used to automatically pull the information from one sheet to another. I have attached a workbooks for your review I had to separate them as the excel file was to large so one is a picture and the other is an excel file.

PRODUCTIVITY ANALYSIS wk2.xls

Excel wkbk1.jpg

The total time, total working hours, total discrepancies and total work is what needs to be compiled in the second workbook from the first workbook. Each employee do the same task but at different times or days, they would be each given their own workbook to save for each month, hopes this helps to explain it.

Each workbook would have a summary of the employees records.

[LIST=1][*]Total Time = to the sum total time spent completing application for the week or month[*]Total Working hours = the same as above, the sum total amount of time on task like Application[*]Total discrepancies= the total sum of time spent completing a task in a given week or month[*]Total working hours = the total sum for the week or month

So lets say in a given week or month an employee completed the task Applications at least ten times, what I want the formula to pull is the total time, total hours total discrepancies, total working hours and completing that specific task.

Thank you I would review it an let you know, sorry for all the mix up and the back and forth.

Thank you I would review it an let you know, sorry for all the mix up and the back and forth. I looked at the formulas and maybe you are still a bit confused. let me tray and explain again.

I had to post the workbooks separately because it was too big, it is actually on document. On workbook 1 which is a monthly sheet, outlines the task to be completed by an employee for a given month, each employee can do the same task nay not necessarily at the same time. What I want to be able to do on workbook 2 is calculate a weekly analysis of the the total task done per week.

So lets say that in workbook 1 during week one for example April 1, 2013 to April 5, 2013 the employee completed a task (applications) three times, In workbook 2 the weekly analysis I want be able to calculate the total time spent in that week to complete that one specific task (applications), as stated each employee would be given separate work books to use.

Hope this helps.

Thanks for all you help though.
Cheril Ann