Hi,
I have the total number of employees allocated to each shift, what is the best way to formulate to show the count of each employee in an interval for each day of the month.
M-F 8am -5pm-: 20 employees
M-Sat 6am -3 pm, with wednesday off: 10 employees
How do I formulate this show I can summarize the count so that I can know how many employees are working on Monday between 2:00-2:30pm?
I want to go even further and reference dates to show new hires joining the taskforce mid-month.
I have the total number of employees allocated to each shift, what is the best way to formulate to show the count of each employee in an interval for each day of the month.
M-F 8am -5pm-: 20 employees
M-Sat 6am -3 pm, with wednesday off: 10 employees
How do I formulate this show I can summarize the count so that I can know how many employees are working on Monday between 2:00-2:30pm?
I want to go even further and reference dates to show new hires joining the taskforce mid-month.
