Need Help with EXCEL Break Schedule

J

jbebay

Hey there. I need help with creating a break schedule for my
employees.

I need to figure out a way to enter their start time and end time and
have the spreadsheet create a break schedule for each department so
that their breaks do not overlap. The rules are as follows:

1. Employees who work more than 7.99 hours get 1 15 min break, 1 30
min break and 1 15 min break
2. Employees who work more than 5.99 hours get 1 15 min break and 1
30 min break.
3. All employees working 3 hours or more get 1 15 min break.
4. Shifts can start anytime after 7am and end at 9pm
5. We have about 7 different areas and each one has about 4-6
employees. No two employees in any one area may go to break at the
same time.

I have figured out how to get an excel spreadsheet to create break
schedules, but when two people start at the same time, it causes them
to have breaks at the same time or in some cases, people who come in
later end up with their 15 min breaks during other's 30 min breaks.
Any help would be really appreciated!!!!!!!!

jb
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top