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

[furd613]

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;
[TABLE="width: 100%"]
<tbody>[TR]
[TD]DATE[/TD]
[TD]Start[/TD]
[TD]Stop[/TD]
[TD]Task[/TD]
[TD]Total Time[/TD]
[/TR]
[TR]
[TD]Jan 4 2016[/TD]
[TD]8:00[/TD]
[TD]10:00[/TD]
[TD]REB[/TD]
[TD]2:00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]10:00[/TD]
[TD]10:30[/TD]
[TD]Adm[/TD]
[TD]0:30[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]10:30[/TD]
[TD]11:30[/TD]
[TD]Mtgs[/TD]
[TD]1:00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]11:30[/TD]
[TD]15:30[/TD]
[TD]Mtgs[/TD]
[TD]4:00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]19:30[/TD]
[TD]20:30[/TD]
[TD]WEF[/TD]
[TD]1:00[/TD]
[/TR]
[TR]
[TD]Jan 5 2016[/TD]
[TD]8:00[/TD]
[TD]9:00[/TD]
[TD]Mtgs[/TD]
[TD]1:00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]9:00[/TD]
[TD]10:00[/TD]
[TD]Adm[/TD]
[TD]1:00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]10:00[/TD]
[TD]11:30[/TD]
[TD]REB[/TD]
[TD]1:30[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]12:01[/TD]
[TD]13:30[/TD]
[TD]REB[/TD]
[TD]1:29[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]15:15[/TD]
[TD]17:00[/TD]
[TD]Mtgs[/TD]
[TD]1:45[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]13:30[/TD]
[TD]14:00[/TD]
[TD]O[/TD]
[TD]0:30[/TD]
[/TR]
[TR]
[TD]Jan 6 2016[/TD]
[TD]6:30[/TD]
[TD]8:30[/TD]
[TD]EdEv[/TD]
[TD]2:00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]8:30[/TD]
[TD]9:30[/TD]
[TD]REB[/TD]
[TD]1:00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]9:30[/TD]
[TD]10:30[/TD]
[TD]WEF[/TD]
[TD]1:00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]10:30[/TD]
[TD]11:59[/TD]
[TD]REB[/TD]
[TD]1:29[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]11:59[/TD]
[TD]14:00[/TD]
[TD]Mtgs[/TD]
[TD]2:01[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]14:00[/TD]
[TD]15:00[/TD]
[TD]Adm[/TD]
[TD]1:00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]15:00[/TD]
[TD]16:00[/TD]
[TD]Adm[/TD]
[TD]1:00[/TD]
[/TR]
</tbody>[/TABLE]

This is a sample of the summary(private) worksheet in book2
[TABLE="width: 100%"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Total Time[/TD]
[/TR]
[TR]
[TD]January 4, 2016[/TD]
[TD]8:30[/TD]
[/TR]
[TR]
[TD]January 5, 2016[/TD]
[TD]7:14[/TD]
[/TR]
[TR]
[TD]January 6, 2016[/TD]
[TD]9:30[/TD]
[/TR]
</tbody>[/TABLE]

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