Aggregating time data in one workbook and automatically populating the results in a second workbook

furd613

New Member
Joined
Jan 26, 2016
Messages
1
I set up two workbooks to track time required to complete tasks. Each workbook has one worksheet, with the variables date and time being in common. I want to share one workbook(book1), while the other is for private use(book2). The shared workbook has individual tasks listed, along with the time required to complete a task as calculated by subtracting the start time from the end time. The number of tasks in any given day can vary.

The private workbook is a summary of all the time taken in a day to complete the tasks. What I would like to do is have the book2 automatically update the total time taken to complete the day’s tasks. At the moment I am using copy/paste links to get the work done, but I want to be able to automate these steps. I am a rank beginner, and can’t figure out any way of getting this done. I’ve reviewed many posts whose titles would suggest that they are similar in nature to my problem, but I’ve not been successful in implementing any solution that appeared to have been useful to the originator of these prior posts. Any help provided is appreciated. Here is a sample of the detailed worksheet in book1;
DATEStartStopTaskTotal Time
Jan 4 20168:0010:00REB2:00
10:0010:30Adm0:30
10:3011:30Mtgs1:00
11:3015:30Mtgs4:00
19:3020:30WEF1:00
Jan 5 20168:009:00Mtgs1:00
9:0010:00Adm1:00
10:0011:30REB1:30
12:0113:30REB1:29
15:1517:00Mtgs1:45
13:3014:00O0:30
Jan 6 20166:308:30EdEv2:00
8:309:30REB1:00
9:3010:30WEF1:00
10:3011:59REB1:29
11:5914:00Mtgs2:01
14:0015:00Adm1:00
15:0016:00Adm1:00

<tbody>
</tbody>

This is a sample of the summary(private) worksheet in book2
DateTotal Time
January 4, 20168:30
January 5, 20167:14
January 6, 20169:30

<tbody>
</tbody>

As a first-time poster I thank you for your help.
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

Forum statistics

Threads
1,213,484
Messages
6,113,923
Members
448,533
Latest member
thietbibeboiwasaco

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top