I kindly ask for assistance with a task I need help automating. 

I have a schedule of tasks to be done by four different employees and need to build an output that

 Assigns the employees based on their scheduled work hours (A3:C6) to tasks (column J) that last 30 minutes (column K)Has a running counter of tasks per employee (column H) so that it when the employee has completed 4 tasks the employee then no longer is assigned tasks. I also need to be able to control the number of tasks; that is, it may be 4 tasks or it may be 2 tasks before the employee is flagged to not be tasked anymore (column J)I also need the flexibility to change hours worked (column D), prep time (column E), and duration of tasks (column K)I also need to be able be able to only schedule an employee after that employee has gone through the prep time (column E)

For example: Employee starts at 3:30am, works duties, the first main task at 7am but before starting must prep for 45 minutes (6:15am) so this employee can’t start a task before 6:15 as the employee needs to prep as well as can’t work no more than 4 tasks and won’t be assigned anymore

I added the helper column (column M) to help manage the tasking for column I. Any other columns can be added to make this work

​I kindly ask for assistance with a task I need help automating.  I have a schedule of tasks to be done by four different employees and need to build an output that Assigns the employees based on their scheduled work hours (A3:C6) to tasks (column J) that last 30 minutes (column K)Has a running counter of tasks per employee (column H) so that it when the employee has completed 4 tasks the employee then no longer is assigned tasks. I also need to be able to control the number of tasks; that is, it may be 4 tasks or it may be 2 tasks before the employee is flagged to not be tasked anymore (column J)I also need the flexibility to change hours worked (column D), prep time (column E), and duration of tasks (column K)I also need to be able be able to only schedule an employee after that employee has gone through the prep time (column E)For example: Employee starts at 3:30am, works duties, the first main task at 7am but before starting must prep for 45 minutes (6:15am) so this employee can’t start a task before 6:15 as the employee needs to prep as well as can’t work no more than 4 tasks and won’t be assigned anymore I added the helper column (column M) to help manage the tasking for column I. Any other columns can be added to make this work  Read More

​