I am looking to create a query from my timeclock database that will show the cumulative staff minutes hour to hour (grouped by department). The table I am using is called dbo.timeclock has all the necessary columns (I believe) they are named: date_in date_out time_in time_out department_desc I want to see a column for every hour (12a-1a, 1a-2a,3a-4a, etc) with the total minutes worked by my staff members for each hour. I.e. employee A clocks in at 7am, employee B clocks in at 7:30. Both work until 9 am. The 7-8a colum should reflect 90 minutes total worked, and the 8a-9a column should reflect 120 minutes worked. I am not sure how to begin to define this query and the logic that goes with it. I would really appreciate guidance/help in writing this one out. Thanks to anyone willing to help on this!