Data by month

[scout01]

Hi I need some help,

I'm managing hours for students over a span of several months. On the first sheet, I have three columns for dates and start times and end times. The amount of dates I get every month varies. On the second sheet, I have columns to show the total hours per month.

I attach an example of what I'm trying to do. Sheet1 contains all the dates and times. Sheet2 is the totals. Sheet3 is what I'm trying to achieve. I want all the totals starting in row 1. I have no idea how to go about this though.

Thanks