Simple Jack 17
New Member
- Joined
- Jun 12, 2018
- Messages
- 1
Hi there,
I maintain aworkbook that has a sheet where the staff schedule is laid out in columns asfollows:
A = Staffmember name
B = MondayStart Time
C = MondayEnd Time
D = TuesdayStart Time
E = TuesdayEnd Time
etc., endingwith M/N for Sunday Start/End Times
Anothersheet includes relevant sales data, labor percentages, etc., for eachindividual day of the week and is printed for day to day use. What I would liketo include on these printouts is a list of Employees and their correspondingStart/End times; and I’m hoping that there is a formula that “grabs” only thoseemployees who are scheduled for that day. So, if there are 12 out of 25 employeesworking on a Sunday, I want the printout to have those 12 employee names listedin column A, with their corresponding start time in column B and end time in C.Any help is appreciated!
I maintain aworkbook that has a sheet where the staff schedule is laid out in columns asfollows:
A = Staffmember name
B = MondayStart Time
C = MondayEnd Time
D = TuesdayStart Time
E = TuesdayEnd Time
etc., endingwith M/N for Sunday Start/End Times
Anothersheet includes relevant sales data, labor percentages, etc., for eachindividual day of the week and is printed for day to day use. What I would liketo include on these printouts is a list of Employees and their correspondingStart/End times; and I’m hoping that there is a formula that “grabs” only thoseemployees who are scheduled for that day. So, if there are 12 out of 25 employeesworking on a Sunday, I want the printout to have those 12 employee names listedin column A, with their corresponding start time in column B and end time in C.Any help is appreciated!
