Spreadsheet: 692946d1598647914-how-do-i-identify-overlapping-date-times-overlaps
Sheet: Sheet1

Day | Date | Start Time | START | END DATE | End Time | END | Amount of overplaps
Tuesday | 2020-09-01 00:00:00 | 21:00:00 |  | 2020-09-02 00:00:00 | 01:00:00
Wednesday | 2020-09-02 00:00:00 | 16:00:00 |  | 2020-09-02 00:00:00 | 22:00:00
Wednesday | 2020-09-02 00:00:00 | 17:00:00 |  | 2020-09-02 00:00:00 | 23:00:00
Wednesday | 2020-09-02 00:00:00 | 19:00:00 |  | 2020-09-03 00:00:00 | 01:00:00
Wednesday | 2020-09-02 00:00:00 | 21:00:00 |  | 2020-09-03 00:00:00 | 03:00:00
Friday | 2020-09-04 00:00:00 | 07:00:00 |  | 2020-09-04 00:00:00 | 16:00:00
Friday | 2020-09-04 00:00:00 | 17:00:00 |  | 2020-09-04 00:00:00 | 23:00:00
Saturday | 2020-09-05 00:00:00 | 18:00:00 |  | 2020-09-06 00:00:00 | 00:00:00
Saturday | 2020-09-05 00:00:00 | 20:30:00 |  | 2020-09-06 00:00:00 | 00:30:00
Sunday | 2020-09-06 00:00:00 | 04:00:00 |  | 2020-09-06 00:00:00 | 08:00:00
Sunday | 2020-09-06 00:00:00 | 08:00:00 |  | 2020-09-06 00:00:00 | 14:00:00
Sunday | 2020-09-06 00:00:00 | 19:00:00 |  | 2020-09-07 00:00:00 | 00:00:00
Monday | 2020-09-07 00:00:00 | 09:00:00 |  | 2020-09-07 00:00:00 | 13:00:00
Monday | 2020-09-07 00:00:00 | 19:00:00 |  | 2020-09-08 00:00:00 | 01:00:00
Tuesday | 2020-09-08 00:00:00 | 19:00:00 |  | 2020-09-08 00:00:00 | 23:00:00
Tuesday | 2020-09-08 00:00:00 | 22:00:00 |  | 2020-09-09 00:00:00 | 04:00:00
Wednesday | 2020-09-09 00:00:00 | 19:00:00 |  | 2020-09-09 00:00:00 | 23:00:00
Thursday | 2020-09-10 00:00:00 | 19:00:00 |  | 2020-09-10 00:00:00 | 23:00:00
Friday | 2020-09-11 00:00:00 | 18:00:00 |  | 2020-09-12 00:00:00 | 00:00:00
Friday | 2020-09-11 00:00:00 | 22:00:00 |  | 2020-09-12 00:00:00 | 02:00:00
Friday | 2020-09-11 00:00:00 | 22:00:00 |  | 2020-09-12 00:00:00 | 02:00:00
Saturday | 2020-09-12 00:00:00 | 08:30:00 |  | 2020-09-12 00:00:00 | 15:00:00
Saturday | 2020-09-12 00:00:00 | 09:00:00 |  | 2020-09-12 00:00:00 | 14:00:00
Saturday | 2020-09-12 00:00:00 | 15:00:00 |  | 2020-09-13 00:00:00 | 03:30:00
Saturday | 2020-09-12 00:00:00 | 16:00:00 |  | 2020-09-12 00:00:00 | 20:00:00
Saturday | 2020-09-12 00:00:00 | 17:00:00 |  | 2020-09-12 00:00:00 | 23:00:00
Saturday | 2020-09-12 00:00:00 | 18:00:00 |  | 2020-09-13 00:00:00 | 00:00:00
Saturday | 2020-09-12 00:00:00 | 19:00:00 |  | 2020-09-13 00:00:00 | 01:00:00
Saturday | 2020-09-12 00:00:00 | 20:30:00 |  | 2020-09-13 00:00:00 | 00:30:00
Sunday | 2020-09-13 00:00:00 | 04:00:00 |  | 2020-09-13 00:00:00 | 06:00:00
Sunday | 2020-09-13 00:00:00 | 06:00:00 |  | 2020-09-13 00:00:00 | 12:00:00
Sunday | 2020-09-13 00:00:00 | 19:00:00 |  | 2020-09-14 00:00:00 | 01:00:00
Sunday | 2020-09-13 00:00:00 | 19:00:00 |  | 2020-09-14 00:00:00 | 01:00:00
Tuesday | 2020-09-15 00:00:00 | 20:00:00 |  | 2020-09-16 00:00:00 | 00:00:00
Wednesday | 2020-09-16 00:00:00 | 00:00:00 |  | 2020-09-16 00:00:00 | 04:00:00
Wednesday | 2020-09-16 00:00:00 | 01:30:00 |  | 2020-09-16 00:00:00 | 04:30:00
Wednesday | 2020-09-16 00:00:00 | 19:00:00 |  | 2020-09-17 00:00:00 | 01:00:00
Thursday | 2020-09-17 00:00:00 | 19:00:00 |  | 2020-09-17 00:00:00 | 23:00:00
Thursday | 2020-09-17 00:00:00 | 21:00:00 |  | 2020-09-18 00:00:00 | 01:00:00
Friday | 2020-09-18 00:00:00 | 18:00:00 |  | 2020-09-18 00:00:00 | 23:00:00
Saturday | 2020-09-19 00:00:00 | 00:00:00 |  | 2020-09-19 00:00:00 | 06:00:00
Saturday | 2020-09-19 00:00:00 | 00:00:00 |  | 2020-09-19 00:00:00 | 07:00:00
Saturday | 2020-09-19 00:00:00 | 07:00:00 |  | 2020-09-19 00:00:00 | 11:00:00
Saturday | 2020-09-19 00:00:00 | 07:00:00 |  | 2020-09-19 00:00:00 | 16:00:00
Saturday | 2020-09-19 00:00:00 | 09:00:00 |  | 2020-09-19 00:00:00 | 15:00:00
Saturday | 2020-09-19 00:00:00 | 12:00:00 |  | 2020-09-19 00:00:00 | 16:00:00
Saturday | 2020-09-19 00:00:00 | 17:00:00 |  | 2020-09-19 00:00:00 | 23:00:00
Saturday | 2020-09-19 00:00:00 | 19:00:00 |  | 2020-09-20 00:00:00 | 01:00:00
Saturday | 2020-09-19 00:00:00 | 22:00:00 |  | 2020-09-20 00:00:00 | 02:00:00
Sunday | 2020-09-20 00:00:00 | 00:00:00 |  | 2020-09-20 00:00:00 | 04:00:00
Sunday | 2020-09-20 00:00:00 | 00:00:00 |  | 2020-09-20 00:00:00 | 06:00:00
Sunday | 2020-09-20 00:00:00 | 00:30:00 |  | 2020-09-20 00:00:00 | 04:30:00
Sunday | 2020-09-20 00:00:00 | 01:00:00 |  | 2020-09-20 00:00:00 | 07:00:00
Sunday | 2020-09-20 00:00:00 | 07:00:00 |  | 2020-09-20 00:00:00 | 15:00:00
Sunday | 2020-09-20 00:00:00 | 09:00:00 |  | 2020-09-20 00:00:00 | 15:00:00
Sunday | 2020-09-20 00:00:00 | 12:00:00 |  | 2020-09-20 00:00:00 | 18:00:00
Sunday | 2020-09-20 00:00:00 | 17:00:00 |  | 2020-09-20 00:00:00 | 23:00:00
Sunday | 2020-09-20 00:00:00 | 19:00:00 |  | 2020-09-20 00:00:00 | 23:00:00
Monday | 2020-09-21 00:00:00 | 21:00:00 |  | 2020-09-22 00:00:00 | 01:00:00
Wednesday | 2020-09-23 00:00:00 | 19:00:00 |  | 2020-09-23 00:00:00 | 23:00:00
Friday | 2020-09-25 00:00:00 | 21:00:00 |  | 2020-09-26 00:00:00 | 02:00:00
Friday | 2020-09-25 00:00:00 | 22:00:00 |  | 2020-09-26 00:00:00 | 04:00:00
Saturday | 2020-09-26 00:00:00 | 00:00:00 |  | 2020-09-26 00:00:00 | 06:00:00
Saturday | 2020-09-26 00:00:00 | 12:00:00 |  | 2020-09-26 00:00:00 | 20:00:00
Saturday | 2020-09-26 00:00:00 | 15:00:00 |  | 2020-09-26 00:00:00 | 19:00:00
Saturday | 2020-09-26 00:00:00 | 19:00:00 |  | 2020-09-26 00:00:00 | 23:00:00
Saturday | 2020-09-26 00:00:00 | 20:00:00 |  | 2020-09-27 00:00:00 | 02:00:00
Saturday | 2020-09-26 00:00:00 | 22:00:00 |  | 2020-09-27 00:00:00 | 04:00:00
Sunday | 2020-09-27 00:00:00 | 05:00:00 |  | 2020-09-27 00:00:00 | 11:00:00
Sunday | 2020-09-27 00:00:00 | 09:00:00 |  | 2020-09-27 00:00:00 | 15:00:00
Sunday | 2020-09-27 00:00:00 | 13:00:00 |  | 2020-09-27 00:00:00 | 17:00:00
Sunday | 2020-09-27 00:00:00 | 17:00:00 |  | 2020-09-27 00:00:00 | 23:00:00
Wednesday | 2020-09-30 00:00:00 | 17:00:00 |  | 2020-09-30 00:00:00 | 21:00:00