I have a table of every hr an employee is available to work. I have managers adding shifts. I want to display a list of employees that are available to work every hr of that shift. So if the shift is 7/21/2020 08:00-14:00 the employee needs a row for 08,09,10,11,12,13,14 probably also needs an 07 but Iโm ignoring that to be faster with making. I donโt currently have an employee table just the list of available hrs for employees.
LinkedIn
Twitter
