Hello all, I am very new to using excel and I wanted to use it to build a work schedule for my employees (over 150 people). I am finding it very difficult to calculate the difference between the time they are scheduled to come in and the time they are scheduled to leave. Employees can only work 5 days a week so on the days when they are not working I have to leave those cells open and I am receiving an error message. Not only do I need to calculate the weekly hours for each individual but also the total amount of hours we are using on a daily basis for the employees. This is where it gets complicated....I want to also account for mandatory meal breaks if the difference between the time when they are scheduled to come in and time time when they are scheduled to leave greater than 6 hours, but less than 6 they must 30 minutes needs to be deducted from the shift. If the difference between the time they come in and the time they leave is greater than 6 hours an hour must be deducted from the shift to account for the unpaid meal break. We have budget hours that are allotted on a weekly basis so I want to be able to put the weekly hours in a cell and have the scheduled hours be deducted from the budgeted hours so we I can see anytime we are either over or under budget. I would appreciate any help that anyone can offer. I have attached an example of the layout i need to use. Workbook7 (version 1).xlsx
Bookmarks