Spreadsheet: 812431d1673139871-if-time-is-within-range-sample_1
Sheet: Table1

Sales Date | Sales Time In | Sales Time Out | Sales Time In | Sales Time Out | Desired Outcome |  |  | Time Range | 00:00:00 | 23:59:00
[NAME] | 09:34 PM | 09:29 AM |  |  | Out of Range
[NAME] | 05:00 PM | 08:00 PM |  |  | In Range
[NAME] | 02:23 PM | 08:00 PM |  |  | In Range
[NAME] | 02:01 PM | 11:28 PM |  |  | In Range
[NAME] | 12:00 PM | 08:00 PM |  |  | In Range
[NAME] | 12:00 PM | 08:00 PM |  |  | In Range
[NAME] | 12:00 PM | 05:00 PM |  |  | In Range
[NAME] | 11:04 AM | 06:02 PM |  |  | In Range
[NAME] | 09:45 AM | 09:43 PM |  |  | In Range
[NAME] | 09:00 AM | 01:00 PM |  |  | In Range
[NAME] | 09:00 AM | 01:00 PM |  |  | In Range
[NAME] | 08:49 AM | 06:58 PM |  |  | In Range
[NAME] | 08:01 AM | 02:24 PM |  |  | In Range
[NAME] | 08:00 AM | 05:01 PM |  |  | In Range
12/23/2022 | 10:27 PM | 09:57 AM |  |  | Out of Range
12/23/2022 | 05:00 PM | 08:00 PM |  |  | In Range
12/23/2022 | 03:00 PM | 09:00 PM |  |  | In Range
12/23/2022 | 03:00 PM | 09:00 PM |  |  | In Range
12/23/2022 | 02:00 PM | 07:00 AM |  |  | Out of Range
12/23/2022 | 12:00 PM | 05:00 PM |  |  | In Range
12/23/2022 | 11:07 AM | 06:00 PM |  |  | In Range
12/23/2022 | 09:00 AM | 10:30 PM |  |  | In Range
12/23/2022 | 09:00 AM | 10:00 PM |  |  | In Range
12/23/2022 | 09:00 AM | 10:00 PM |  |  | In Range
12/23/2022 | 09:00 AM | 01:00 PM |  |  | In Range
12/23/2022 | 09:00 AM | 01:00 PM |  |  | In Range
12/23/2022 | 08:00 AM | 05:00 PM |  |  | In Range
12/23/2022 | 08:00 AM | 08:09 PM |  |  | In Range
[NAME] | 11:13 PM | 09:00 AM |  |  | Out of Range
[NAME] | 07:20 PM | 07:30 AM |  |  | Out of Range
[NAME] | 05:00 PM | 08:00 PM |  |  | In Range
[NAME] | 05:50 PM | 10:42 PM |  |  | In Range
[NAME] | 05:02 PM | 11:22 PM |  |  | In Range
[NAME] | 03:00 PM | 09:00 PM |  |  | In Range
[NAME] | 03:00 PM | 09:00 PM |  |  | In Range
[NAME] | 02:05 PM | 08:11 PM |  |  | In Range
[NAME] | 02:03 PM | 11:27 PM |  |  | In Range
[NAME] | 02:00 PM | 04:30 PM |  |  | In Range
[NAME] | 12:20 PM | 05:22 PM |  |  | In Range
[NAME] | 12:04 PM | 08:04 PM |  |  | In Range
[NAME] | 11:28 AM | 09:13 PM |  |  | In Range
[NAME] | 10:46 AM | 06:02 PM |  |  | In Range
[NAME] | 09:37 AM | 05:48 PM |  |  | In Range
[NAME] | 09:24 AM | 06:31 PM |  |  | In Range
[NAME] | 09:22 AM | 04:57 PM |  |  | In Range
[NAME] | 09:00 AM | 01:00 PM |  |  | In Range
[NAME] | 09:00 AM | 01:00 PM |  |  | In Range
[NAME] | 07:58 AM | 05:00 PM |  |  | In Range
[NAME] | 07:58 AM | 02:01 PM |  |  | In Range
12/21/2022 | 11:08 PM | 09:30 AM |  |  | Out of Range
12/21/2022 | 07:20 PM | 07:30 AM |  |  | Out of Range
12/21/2022 | 05:01 PM | 11:24 PM |  |  | In Range
12/21/2022 | 03:00 PM | 09:00 PM |  |  | In Range
12/21/2022 | 03:00 PM | 09:00 PM |  |  | In Range
12/21/2022 | 02:31 PM | 07:55 PM |  |  | In Range
12/21/2022 | 02:31 PM | 08:06 PM |  |  | In Range
12/21/2022 | 02:02 PM | 11:00 PM |  |  | In Range
12/21/2022 | 02:00 PM | 04:31 PM |  |  | In Range
12/21/2022 | 12:16 PM | 08:16 PM |  |  | In Range
12/21/2022 | 10:58 AM | 06:10 PM |  |  | In Range
12/21/2022 | 10:31 AM | 06:46 PM |  |  | In Range
12/21/2022 | 09:28 AM | 06:31 PM |  |  | In Range
12/21/2022 | 09:15 AM | 09:58 PM |  |  | In Range
12/21/2022 | 09:00 AM | 04:01 PM |  |  | In Range
12/21/2022 | 09:00 AM | 05:00 PM |  |  | In Range
12/21/2022 | 09:00 AM | 01:00 PM |  |  | In Range
12/21/2022 | 09:00 AM | 01:00 PM |  |  | In Range
12/21/2022 | 06:00 AM | 09:02 AM |  |  | In Range
12/21/2022 | 05:58 AM | 08:30 AM |  |  | In Range
[NAME] | 10:44 PM | 09:08 AM |  |  | Out of Range
[NAME] | 07:20 PM | 07:30 AM |  |  | Out of Range
[NAME] | 05:55 PM | 11:10 PM |  |  | In Range
[NAME] | 04:59 PM | 11:06 PM |  |  | In Range
[NAME] | 04:30 PM | 08:00 PM |  |  | In Range
[NAME] | 03:02 PM | 07:07 PM |  |  | In Range
[NAME] | 03:00 PM | 07:00 PM |  |  | In Range
[NAME] | 03:00 PM | 09:00 PM |  |  | In Range
[NAME] | 03:00 PM | 09:00 PM |  |  | In Range
[NAME] | 02:59 PM | 10:57 PM |  |  | In Range
[NAME] | 02:33 PM | 07:24 PM |  |  | In Range
[NAME] | 02:30 PM | 04:30 PM |  |  | In Range
[NAME] | 02:03 PM | 04:38 PM |  |  | In Range
[NAME] | 10:50 AM | 06:32 PM |  |  | In Range
[NAME] | 09:39 AM | 02:05 PM |  |  | In Range
[NAME] | 09:35 AM | 05:20 PM |  |  | In Range
[NAME] | 09:23 AM | 06:34 PM |  |  | In Range
[NAME] | 09:17 AM | 05:09 PM |  |  | In Range
[NAME] | 09:00 AM | 05:00 PM |  |  | In Range
[NAME] | 09:00 AM | 01:00 PM |  |  | In Range
[NAME] | 09:00 AM | 01:00 PM |  |  | In Range
[NAME] | 06:01 AM | 08:30 AM |  |  | In Range
12/19/2022 | 10:04 PM | 09:33 AM |  |  | Out of Range
12/19/2022 | 07:20 PM | 07:30 AM |  |  | In Range
12/19/2022 | 03:20 PM | 09:46 PM |  |  | In Range
12/19/2022 | 03:08 PM | 07:12 PM |  |  | In Range
12/19/2022 | 03:00 PM | 09:00 PM |  |  | In Range
12/19/2022 | 03:00 PM | 09:00 PM |  |  | In Range
12/19/2022 | 02:36 PM | 08:00 PM |  |  | In Range
12/19/2022 | 02:30 PM | 08:08 PM |  |  | In Range
12/19/2022 | 03:00 PM | 10:04 PM |  |  | In Range
12/19/2022 | 02:12 PM | 10:33 PM |  |  | In Range
12/19/2022 | 02:00 PM | 04:30 PM |  |  | In Range
12/19/2022 | 12:31 PM | 08:31 PM |  |  | In Range
12/19/2022 | 10:49 AM | 06:14 PM |  |  | In Range
12/19/2022 | 10:30 AM | 06:00 PM |  |  | In Range
12/19/2022 | 09:29 AM | 06:40 PM |  |  | In Range
12/19/2022 | 09:00 AM | 01:00 PM |  |  | In Range
12/19/2022 | 09:00 AM | 01:00 PM |  |  | In Range
12/19/2022 | 08:00 AM | 12:05 PM |  |  | In Range
12/19/2022 | 05:59 AM | 09:05 AM |  |  | In Range
12/19/2022 | 05:59 AM | 08:30 AM |  |  | In Range
12/18/2022 | 10:00 PM | 09:30 AM |  |  | In Range
12/18/2022 | 05:10 PM | 08:00 PM |  |  | In Range
12/18/2022 | 12:00 PM | 08:00 PM |  |  | In Range
12/18/2022 | 12:00 PM | 08:00 PM |  |  | In Range
12/18/2022 | 10:58 AM | 06:58 PM |  |  | In Range
12/18/2022 | 10:48 AM | 06:05 PM |  |  | In Range
12/18/2022 | 10:06 AM | 02:30 PM |  |  | In Range
12/18/2022 | 09:46 AM | 09:54 PM |  |  | In Range
12/18/2022 | 09:00 AM | 04:30 PM |  |  | In Range
12/18/2022 | 09:00 AM | 01:00 PM |  |  | In Range
12/18/2022 | 09:00 AM | 01:00 PM |  |  | In Range
12/18/2022 | 08:54 AM | 06:33 PM |  |  | In Range
12/18/2022 | 07:49 AM | 05:03 PM |  |  | In Range
12/18/2022 | 02:30 PM | 08:00 PM |  |  | In Range
[NAME] | 09:31 PM | 09:11 AM |  |  | Out of Range