LyndsayYYC
New Member
- Joined
- Feb 22, 2021
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
I have a spreadsheet with data outputted from our scheduling system. Our employees work in multiple locations sometimes in the same shift so the system "divides" their times based on location so one person's shift may be 3 lines in my chart. Is there a way to extract the earliest start time and latest end time and make it display as one shift??
example of data I get... but I need like DICKINSON to be one line showing shift as 0800-1800 instead of 2 lines. (there is also one that is an overnight shift which I am sure is a whole other bucket of fun)
example of data I get... but I need like DICKINSON to be one line showing shift as 0800-1800 instead of 2 lines. (there is also one that is an overnight shift which I am sure is a whole other bucket of fun)
EE | Name | From | To |
1 | DICKINSON, LINDSAY JOAN | 08:00 | 16:30 |
1 | DICKINSON, LINDSAY JOAN | 16:30 | 18:00 |
2 | SRAN, NAVDEEP | 06:00 | 12:30 |
2 | SRAN, NAVDEEP | 12:30 | 14:00 |
3 | BAJWA, WARDA | 10:00 | 16:30 |
3 | BAJWA, WARDA | 16:30 | 18:00 |
4 | KAHRIMAN, ALBIN | 04:30 | 13:00 |
4 | KAHRIMAN, ALBIN | 13:00 | 14:30 |
5 | SANDHU, AMRINDER | 08:05 | 13:00 |
5 | SANDHU, AMRINDER | 13:00 | 14:30 |
6 | BHULLAR, LOVEJIT | 18:00 | 19:30 |
6 | BHULLAR, LOVEJIT | 19:30 | 04:00 |