Spreadsheet: 96254d1295646880-overlapping-time-formula-book1
Sheet: Management Breaks and Lunches

SUNDAY | First Name | Last Name | Schedule | Break | Lunch | Break 2
 |  |  | 07:00 AM - 03:30 PM | 09:30 AM -09:45 AM | 11:15 AM -11:45 AM | 01:45 PM -02:00 PM
 |  |  | 08:00 AM - 04:30 PM | 10:00 AM -10:15 AM | 12:00 PM -12:30 PM | 02:30 PM -02:45 PM
 |  |  | 08:00 AM - 04:30 PM | 10:15 AM -10:30 AM | 12:15 PM -12:45 PM | 02:45 PM -03:00 PM
 |  |  | 10:30 AM - 06:00 PM | 11:45 AM -12:00 PM | 02:00 PM -02:30 PM | 05:15 PM -05:30 PM
 |  |  | 01:30 PM - 10:00 PM | 03:45 PM -04:00 PM | 05:00 PM -05:30 PM | 07:45 PM -08:00 PM
 |  |  | 01:30 PM - 10:00 PM | 02:45 PM -03:00 PM | 05:15 PM -05:45 PM | 07:30 PM -07:45 PM
 |  |  | 01:30 PM - 10:00 PM | 03:00 PM -03:15 PM | 06:00 PM -06:30 PM | 08:00 PM -08:15 PM
MONDAY | First Name | Last Name | Schedule | Break | Lunch | Break2
 |  |  | 07:00 AM - 03:30 PM | 09:30 AM -09:45 AM | 11:15 AM -11:45 AM | 01:45 PM -02:00 PM
 |  |  | 08:00 AM - 04:30 PM | 10:00 AM -10:15 AM | 12:00 PM -12:30 PM | 02:30 PM -02:45 PM
 |  |  | 08:00 AM - 04:30 PM | 10:15 AM -10:30 AM | 12:15 PM -12:45 PM | 02:45 PM -03:00 PM
 |  |  | 08:00 AM - 04:30 PM | 10:30 AM -10:45 AM | 12:45 PM -01:15 PM | 03:00 PM -03:15 PM
 |  |  | 10:30 AM - 06:00 PM | 11:45 AM -12:00 PM | 02:00 PM -02:30 PM | 04:30 PM -04:45 PM
 |  |  | 01:00 PM - 09:30 PM | 02:45 PM -03:00 PM | 05:00 PM -05:30 PM | 07:00 PM -07:15 PM
 |  |  | 01:30 PM - 10:00 PM | 03:45 PM -04:00 PM | 05:20 PM -05:40 PM | 07:45 PM -08:00 PM
 |  |  | 01:30 PM - 10:00 PM | 03:15 PM -03:30 PM | 06:00 PM -06:30 PM | 08:00 PM -08:15 PM
 |  |  | 01:30 PM - 10:00 PM | 03:30 PM -03:45 PM | 04:45 PM -05:15 PM | 07:15 PM -07:30 PM
 | First Name | Last Name | Schedule | Break | Lunch | Break2
 |  |  | 07:00 AM - 03:30 PM | 09:30 AM -09:45 AM | 11:15 AM -11:45 AM | 01:45 PM -02:00 PM
 |  |  | 08:00 AM - 04:30 PM | 10:15 AM -10:30 AM | 12:30 PM -01:00 PM | 03:00 PM -03:15 PM
 |  |  | 08:00 AM - 04:30 PM | 10:30 AM -10:45 AM | 01:00 PM -01:30 PM | 03:00 PM -03:15 PM
 |  |  | 08:30 AM - 05:00 PM | 10:45 AM -11:00 PM | 02:00 PM -02:30 PM | 03:30 PM -03:45 PM
 |  |  | 09:00 AM - 05:30 PM | 11:00 PM -11:15 PM | 01:30 PM -02:00 PM | 03:45 PM -04:00 PM
 |  |  | 09:30 AM - 06:00 PM | 11:15 PM -11:30 PM | 02:30 PM -03:00 PM | 03:15 PM -03:30 PM
 |  |  | 10:00 AM - 06:30 PM | 12:00 PM -12:15 PM | 03:00 PM -03:30 PM | 04:30 PM -04:45 PM
 |  |  | 10:30 AM - 07:00 PM | 12:15 PM -12:30 PM | 02:30 PM -03:00 PM | 05:15 PM -05:30 PM
 |  |  | 11:00 AM - 07:30 PM | 12:30 PM -12:45 PM | 02:30 PM -03:00 PM | 05:00 PM -05:15 PM
 |  |  | 11:30 AM - 08:00 PM | 12:45 PM -01:00 PM | 03:30 PM -04:00 PM | 05:00 PM -05:15 PM
 |  |  | 11:30 AM - 08:00 PM | 01:00 PM -01:15 PM | 04:00 PM -04:30 PM | 05:30 PM -05:45 PM
 |  |  | 12:30 PM - 09:00 PM | 02:00 PM -02:15 PM | 04:30 PM -05:00 PM | 06:45 PM -07:00 PM
 |  |  | 01:00 PM - 09:30 PM | 02:45 PM -03:00 PM | 05:00 PM -05:30 PM | 07:00 PM -07:15 PM
 |  |  | 01:30 PM - 10:00 PM | 03:45 PM -04:00 PM | 05:30 PM - 06:30 PM | 07:45 PM -08:00 PM
 |  |  | 01:30 PM - 10:00 PM | 03:00 PM -03:15 PM | 06:00 PM -06:30 PM | 08:00 PM -08:15 PM
 |  |  | 01:30 PM - 10:00 PM | 03:15 PM -03:30 PM | 04:45 PM -05:15 PM | 07:15 PM -07:30 PM
 | First Name | Last Name | Schedule | Break | Lunch | Break2
 |  |  | 07:00 AM - 03:30 PM | 09:30 AM -09:45 AM | 11:15 AM -11:45 AM | 01:45 PM -02:00 PM
 |  |  | 08:00 AM - 04:30 PM | 10:15 AM -10:30 AM | 12:30 PM -01:00 PM | 03:00 PM -03:15 PM
 |  |  | 08:00 AM - 04:30 PM | 10:30 AM -10:45 AM | 01:00 PM -01:30 PM | 03:00 PM -03:15 PM
 |  |  | 08:30 AM - 05:00 PM | 11:15 AM -11:30 AM | 01:30 PM -02:00 PM | 03:45 PM -04:00 PM
 |  |  | 09:00 AM - 05:30 PM | 11:45 AM -12:00 PM | 02:15 PM -02:45 PM | 04:30 PM -04:45 PM
 |  |  | 09:30 AM - 06:00 PM | 12:30 PM -12:45 PM | 02:30 PM -03:00 PM | 05:00 PM -05:15 PM
 |  |  | 10:30 AM - 07:00 PM | 11:00 AM -11:15 AM | 02:00 PM -02:30 PM | 03:30 PM -03:45 PM
 |  |  | 11:00 AM - 07:30 PM | 02:00 PM -02:15 PM | 04:30 PM -05:00 PM | 06:45 PM -07:00 PM
 |  |  | 11:00 AM - 07:30 PM | 03:45 PM -04:00 PM | 05:20 PM -05:40 PM | 07:45 PM -08:00 PM
 |  |  | 11:30 AM - 08:00 PM | 11:45 AM -12:00 PM | 02:00 PM -02:30 PM | 03:15 PM -03:30 PM
 |  |  | 11:30 AM - 08:00 PM | 11:45 AM -12:00 PM | 02:30 PM -03:00 PM | 05:15 PM -05:30 PM
 |  |  | 11:30 AM - 08:00 PM | 12:45 PM -01:00 PM | 03:15 PM -03:45 PM | 05:30 PM -05:45 PM
 |  |  | 12:30 PM - 09:00 PM | 12:45 PM -01:00 PM | 03:00 PM -03:30 PM | 05:00 PM -05:15 PM
 |  |  | 01:30 PM - 10:00 PM | 02:45 PM -03:00 PM | 05:00 PM -05:30 PM | 07:00 PM -07:15 PM
 |  |  | 01:30 PM - 10:00 PM | 03:00 PM -03:15 PM | 06:00 PM -06:30 PM | 08:00 PM -08:15 PM
 |  |  | 01:30 PM - 10:00 PM | 03:00 PM -03:15 PM | 04:45 PM -05:15 PM | 07:15 PM -07:30 PM
 | First Name | Last Name | Schedule | Break | Lunch | Break2
 |  |  | 07:00 AM - 03:30 PM | 09:30 AM -09:45 AM | 11:15 AM -11:45 AM | 01:45 PM -02:00 PM
 |  |  | 08:00 AM - 04:30 PM | 10:15 AM -10:30 AM | 12:30 PM -01:00 PM | 03:00 PM -03:15 PM
 |  |  | 08:00 AM - 04:30 PM | 10:30 AM -10:45 AM | 01:00 PM -01:30 PM | 03:00 PM -03:15 PM
 |  |  | 08:00 AM - 04:30 PM
 |  |  | 08:00 AM - 04:30 PM
 |  |  | 08:30 AM - 05:00 PM
 |  |  | 09:00 AM - 05:30 PM
 |  |  | 10:00 AM - 06:30 PM
 |  |  | 10:00 AM - 06:30 PM
 |  |  | 10:30 AM - 07:00 PM
 |  |  | 11:00 AM - 07:30 PM
 |  |  | 11:00 AM - 07:30 PM
 |  |  | 11:30 AM - 08:00 PM
 |  |  | 11:30 AM - 08:00 PM
 |  |  | 01:00 PM - 09:30 PM
 |  |  | 01:30 PM - 10:00 PM
 |  |  | 01:30 PM - 10:00 PM
 |  |  | 01:30 PM - 10:00 PM
 |  |  | 01:30 PM - 10:00 PM
 | First Name | Last Name | Schedule | Break | Lunch | Break2
 |  |  | 07:00 AM - 03:30 PM
 |  |  | 08:00 AM - 04:30 PM
 |  |  | 08:00 AM - 04:30 PM
 |  |  | 08:00 AM - 04:30 PM
 |  |  | 08:00 AM - 04:30 PM
 |  |  | 08:30 AM - 05:00 PM
 |  |  | 09:00 AM - 05:30 PM
 |  |  | 09:30 AM - 06:00 PM
 |  |  | 10:00 AM - 06:30 PM
 |  |  | 10:30 AM - 07:00 PM
 |  |  | 11:00 AM - 07:30 PM
 |  |  | 11:00 AM - 07:30 PM
 |  |  | 11:30 AM - 08:00 PM
 |  |  | 11:30 AM - 08:00 PM
 |  |  | 12:30 PM - 09:00 PM
 |  |  | 01:00 PM - 09:30 PM
 |  |  | 01:30 PM - 10:00 PM
 |  |  | 01:30 PM - 10:00 PM
 |  |  | 01:30 PM - 10:00 PM
 | First Name | Last Name | Schedule | Break | Lunch | Break2
 |  |  | 07:00 AM - 03:30 PM
 |  |  | 08:00 AM - 04:30 PM
 |  |  | 08:00 AM - 04:30 PM
 |  |  | 09:00 AM - 05:30 PM
 |  |  | 09:30 AM - 06:00 PM
 |  |  | 09:30 AM - 06:00 PM
 |  |  | 10:00 AM - 06:30 PM
 |  |  | 10:00 AM - 06:30 PM
 |  |  | 11:00 AM - 07:30 PM
 |  |  | 11:00 AM - 07:30 PM
 |  |  | 11:30 AM - 08:00 PM
 |  |  | 01:30 PM - 10:00 PM
 |  |  | 01:30 PM - 10:00 PM
 |  |  | 01:30 PM - 10:00 PM