Hi there, first time posting, but I've been using excel for several year, but not very advanced, nor taken any classes.
I created this workbook today that I want to use at work.
In the first sheet, it is simply a schedule that has been copied and pasted from our store's scheduling program, so can't change the formatting on that
I have a blank page on how the daily sheets are formatted.
Then on each page, i have the appropriate data pulled from the full schedule starting with column Z. The tables (not Excel Tables) for each type of position have formulas that extract the data from the daily schedule which fill in only the names of the people scheduled for that day, and their shift.
The problem I've run into, and not sure where to start, is that there will occasionally be split shifts, as you can see with Monday and Tuesday.
Manager 3 has a split shift on monday, but the monday sheet is only displaying the first shift.
Manager 1 has a split shift on tuesday, same problem.
Then, what I'd like to do, is have each area of the sheet sorted first by the in times of the employees, and then the out times
Bookmarks