MS Access 2010 query showing work minutes completed in each hour by task within a shift

[Wingfoot]

Hi

I'm trying to organise the data shown below so that it calculates the number of minutes a particular task was carried out for, within in each hour, over a 12 hour shift from 06:00 to 18:00. See raw data below:


[TABLE="width: 661"]
<tbody>[TR]
[TD]Date[/TD]
[TD]ID[/TD]
[TD]Last Name[/TD]
[TD]First Name[/TD]
[TD]Actual Start[/TD]
[TD]Actual End[/TD]
[TD]Activity description[/TD]
[/TR]
[TR]
[TD]19/04/2015[/TD]
[TD]6921798[/TD]
[TD]Smith[/TD]
[TD]John[/TD]
[TD]19/04/2015 16:34[/TD]
[TD]19/04/2015 16:50[/TD]
[TD]Breaks[/TD]
[/TR]
[TR]
[TD]19/04/2015[/TD]
[TD]6921798[/TD]
[TD]Smith[/TD]
[TD]John[/TD]
[TD]19/04/2015 14:35[/TD]
[TD]19/04/2015 16:34[/TD]
[TD]D1 Marshalling[/TD]
[/TR]
[TR]
[TD]19/04/2015[/TD]
[TD]6921798[/TD]
[TD]Smith[/TD]
[TD]John[/TD]
[TD]19/04/2015 16:50[/TD]
[TD]19/04/2015 18:00[/TD]
[TD]D1 Marshalling[/TD]
[/TR]
[TR]
[TD]19/04/2015[/TD]
[TD]6921798[/TD]
[TD]Smith[/TD]
[TD]John[/TD]
[TD]19/04/2015 14:05[/TD]
[TD]19/04/2015 14:35[/TD]
[TD]Breaks[/TD]
[/TR]
[TR]
[TD]19/04/2015[/TD]
[TD]6921798[/TD]
[TD]Smith[/TD]
[TD]John[/TD]
[TD]19/04/2015 10:18[/TD]
[TD]19/04/2015 14:05[/TD]
[TD]D1 Marshalling[/TD]
[/TR]
[TR]
[TD]19/04/2015[/TD]
[TD]6921798[/TD]
[TD]Smith[/TD]
[TD]John[/TD]
[TD]19/04/2015 06:06[/TD]
[TD]19/04/2015 10:04[/TD]
[TD]DC1 Loading Other[/TD]
[/TR]
[TR]
[TD]19/04/2015[/TD]
[TD]6921798[/TD]
[TD]Smith[/TD]
[TD]John[/TD]
[TD]19/04/2015 10:04[/TD]
[TD]19/04/2015 10:18[/TD]
[TD]Breaks[/TD]
[/TR]
[TR]
[TD]19/04/2015[/TD]
[TD]6921798[/TD]
[TD]Smith[/TD]
[TD]John[/TD]
[TD]19/04/2015 05:52[/TD]
[TD]19/04/2015 06:04[/TD]
[TD]Briefing[/TD]
[/TR]
[TR]
[TD]19/04/2015[/TD]
[TD]6921798[/TD]
[TD]Smith[/TD]
[TD]John[/TD]
[TD]19/04/2015 06:04[/TD]
[TD]19/04/2015 06:06[/TD]
[TD]D1 Stock[/TD]
[/TR]
</tbody><colgroup><col><col><col><col><col><col><col></colgroup>[/TABLE]


This is the format I'd like to convert the data to using a query:


[TABLE="width: 883"]
<tbody>[TR]
[TD]Date[/TD]
[TD]ID[/TD]
[TD]Last Name[/TD]
[TD]First Name[/TD]
[TD]Activity description[/TD]
[TD]06:00[/TD]
[TD]07:00[/TD]
[TD]08:00[/TD]
[TD]09:00[/TD]
[TD]10:00[/TD]
[TD]11:00[/TD]
[TD]12:00[/TD]
[TD]13:00[/TD]
[TD]14:00[/TD]
[TD]15:00[/TD]
[TD]16:00[/TD]
[TD]17:00[/TD]
[/TR]
[TR]
[TD]19/04/2015[/TD]
[TD]6921798[/TD]
[TD]Smith[/TD]
[TD]John[/TD]
[TD]Briefing[/TD]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]19/04/2015[/TD]
[TD]6921799[/TD]
[TD]Smith[/TD]
[TD]John[/TD]
[TD]D1 Stock[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]19/04/2015[/TD]
[TD]6921800[/TD]
[TD]Smith[/TD]
[TD]John[/TD]
[TD]DC1 Loading Other[/TD]
[TD]54[/TD]
[TD]60[/TD]
[TD]60[/TD]
[TD]60[/TD]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]19/04/2015[/TD]
[TD]6921801[/TD]
[TD]Smith[/TD]
[TD]John[/TD]
[TD]Breaks[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]14[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]19/04/2015[/TD]
[TD]6921802[/TD]
[TD]Smith[/TD]
[TD]John[/TD]
[TD]D1 Marshalling[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]42[/TD]
[TD]60[/TD]
[TD]60[/TD]
[TD]60[/TD]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]19/04/2015[/TD]
[TD]6921803[/TD]
[TD]Smith[/TD]
[TD]John[/TD]
[TD]Breaks[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]30[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]19/04/2015[/TD]
[TD]6921804[/TD]
[TD]Smith[/TD]
[TD]John[/TD]
[TD]D1 Marshalling[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]25[/TD]
[TD]60[/TD]
[TD]34[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]19/04/2015[/TD]
[TD]6921805[/TD]
[TD]Smith[/TD]
[TD]John[/TD]
[TD]Breaks[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]16[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]19/04/2015[/TD]
[TD]6921806[/TD]
[TD]Smith[/TD]
[TD]John[/TD]
[TD]D1 Marshalling[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]10[/TD]
[TD]60[/TD]
[/TR]
</tbody><colgroup><col><col><col><col><col><col span="12"></colgroup>[/TABLE]


So, for example, in the first hour from 6:00 to 7:00, there were 3 different activities which took 4 minutes, 2 minutes and 54 minutes respectively, all together making up the 60 minutes.
Many thanks for your help.