Hello all,
I am looking for a way to create a spreadsheet that will automatically schedule breaks and lunches for an employee base of about 60 people over a 7-day period. There are a mixture of part-time and full-time employees. We are a 24x7 shop and there are certain criteria that the spreadsheet would need to consider when running the macros:
1. There must be a certain number of employees on during each hour interval
2. Breaks & lunches have to be taken during a specific time in the employee's shift (ex.: lunch must be taken between the 3rd and 6th hour of the shift)
My question is two-fold: is this possible? And, I am very new to VBA and would like to learn how to write the macro, so can anyone point me in the direction of a book or other site that will teach me what I need to know? I would rather not have to take a class.
Unfortunately purchasing software for this function is out of the question at the moment, so I'm hopeful that Excel will give me what I need.
I have also posted this question here: http://www.mrexcel.com/forum/excel-q...cheduling.html
Thank you in advance.
Bookmarks