I am looking for a function that will read a csv file containing employees schedule date & time and identify all the overlapping records.
Below is an example of what the file looks like and what would be considered an overlapping schedule.
,A1236 ,J A ,4/26/2019,3:00:00 AM,11:00:00 AM,1,7,,,
,A1236 ,J A ,4/25/2019,3:00:00 PM,7:00:00 AM,2,14,,,
"It's because those two TS in the spreadsheet for 4/25/ and 4/26 are overlapped (just put them in correct order - TS 4/25 ends next day at 7AM ):"