I am trying to calculate the number of complete hours staff has worked at different times during the day. It is a 24/7 schedule.
Below is an example of how the data looks (there are thousands and thousands of rows like this). An Id that represent a staff member, and date/time when they start work and end work.
I am trying to figure out how to calculate the number of fully completed scheduled working hours that there are at different times during the day...i.e. between 0800 - 0900, 0900 - 1000, 2200 - 2300 ...(at all hours during the day). I am interested in both fully completed hours but also partly completed hours, i.e. start at 0730...or end at 1615.
I want to be able to select several days or weeks to see aggregated statistics for scheduled hours at different times during the day.
Right now I am stuck ... I include an example app .