Automated random work schedule

Are people limited to one time slot per day?

Hello gsebi and Welcome to Excel Forum.
Have you looked at the "Similar Threads" listed in the window at the bottom of this page.
I feel that we are going to need more information and probably a manually produced file to serve as a guide with which we can compare the results of our proposed formulas/code.
Let us know if you have any questions.

Hello JeteMc,
first of all thanks for your post. I have attached what I have managed so far as a file. I tried on page 2 with some calculations but at the end I didn't know how that could help me to automate it.
Hope with my explanation from the top of the post everything should make sense now. The employees numbers will be changed by names later logically.

Thanks a lot for all your help in advance!

It seems as if you are not too far along with this project, in which case I recommend that you convert the entry from a matrix style as originally displayed on the Schedule sheet to a records format as displayed in E8:I33 on the Calculations sheet.
The formula for then become a relatively simple: =SUMIFS($H9:$H33,$I9:$I33,E3)
Let us know if you have any questions.

Thank you very much.

The only thing that's missing me know is the randomized process. When i update excel then there should be new employees every time still trying to come close to there number of hours they should work.
I think at work, variety is always good.
How can I randomize that and automate it so I don't have to put the employees in manually?
Furthermore, I would need the possibility to indicate when a person can not work and this date/dates are then automatically not entered for this employee.

As to randomization perhaps setting up schedules where employees switch days/hours with others that have similar total hours that they should work and then having a formula index which randomly selected schedule to use that week would help.
The formula for F8:F33 is: =INDEX(I8:J8,MATCH(MIN(I$6:J$6),I$6:J$6,0))
Press the F9 key to change change the random values in I6:J6 (note that this will not always change the schedule selected).
As to employees that can not work on certain days, I feel that the easiest answer is to manually replace their number in column F. Note that once a number is manually placed in column F the formula in that cell is erased, so before the producing the next week's schedule select cell F8 and double click the fill handle to place the formula back into the cells below.
Let us know if you have any questions.