I have a work schedule for each day of the week. Each day has three columns of information-1) the area and time working-COLUMN A 2) the total hours-COLUMN B 3) the employee assigned-COLUMN C.
An employee can be listed in multiple times on any given day and can be assigned different areas (rows) over the work week.
When preparing the schedule, I want to have a running total of hours I have assigned by employee to make sure that they are scheduled for the right amount of hours. Ideally, if I were able to have ALL the employees listed and as I modify the schedule their respective total hours would adjust accordingly.
Help Please!
Bookmarks