Spreadsheet: 807307d1669835966-countifs-not-working-from-10-59-59-pm-to-07-00-00-am-countifs-not-working-from-pm-to-am
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | 1st |  |  |  |  |  | 2nd |  |  |  |  | 3rd
 |  |  |  |  |  |  |  |  |  | 2022-11-28 00:00:00 | 2022-11-29 00:00:00 | 2022-11-30 00:00:00 |  |  |  | 2022-11-28 00:00:00 | 2022-11-29 00:00:00 | 2022-11-30 00:00:00 |  |  | 2022-11-28 00:00:00 | 2022-11-29 00:00:00 | 2022-11-30 00:00:00
 |  |  |  | Shift Change | Normal Times
 |  |  |  | 06:59:59 | 06:59:59 | Line Waiting
 |  |  |  | 15:05:59 | 15:00:00 | Material
 |  |  |  | 14:59:59 | 14:59:59 | Change Over
 |  |  |  | 23:05:59 | 23:00:00 | Breaks/Lunches
 |  |  |  | 22:59:59 | 22:59:59 | IT
 |  |  |  | 07:05:59 | 07:00:00 | IT*
 |  |  |  |  |  | Unknown
 |  |  |  |  | 00:00:01 | Mechanical Failure
 |  |  |  |  |  | Shift Change
 |  |  |  |  |  | Quality*
 |  |  |  |  |  | 5S
 |  |  |  |  |  | Personnel*
 |  |  |  |  |  |  |  |  | Quality* | 2022-11-29 02:42:47 | 2022-11-29 02:50:00 | 2022-11-29 06:01:16 | 433 | 0:07:13 | 1 | printing out bad labels had to get [NAME] to fix | 2022-11-29 00:00:00 | 02:42:47 | 2022-11-29 00:00:00 | 02:50:00
 |  |  |  |  |  |  |  |  | Quality* | 2022-11-29 02:50:00 | 2022-11-29 02:52:14 | 2022-11-29 06:01:16 | 134 | 0:02:14 | 1 | printing out bad labels had to get [NAME] to fix | 2022-11-29 00:00:00 | 02:50:00 | 2022-11-29 00:00:00 | 02:52:14
 |  |  |  |  |  |  |  |  | Quality* | 2022-11-29 03:04:43 | 2022-11-29 03:09:37 | 2022-11-29 06:47:54 | 294 | 0:04:54 | 1 | op210  had another bad label had to get [NAME] to adjust again | 2022-11-29 00:00:00 | 03:04:43 | 2022-11-29 00:00:00 | 03:09:37
 |  |  |  |  |  |  |  |  | Quality* | 2022-11-29 12:05:32 | 2022-11-29 12:11:51 | 2022-11-29 13:43:27 | 379 | 0:06:19 | 1 | Quality analysis on DT strut bananas | 2022-11-29 00:00:00 | 12:05:32 | 2022-11-29 00:00:00 | 12:11:51
 |  |  |  |  |  |  |  |  | Quality* | 2022-11-29 12:11:51 | 2022-11-29 12:21:40 | 2022-11-29 13:43:40 | 589 | 0:09:49 | 1 | Quality analysis on DT strut bananas | 2022-11-29 00:00:00 | 12:11:51 | 2022-11-29 00:00:00 | 12:21:40
 |  |  |  |  |  |  |  |  | Quality* | 2022-11-29 19:28:51 | 2022-11-29 19:39:39 | 2022-11-29 21:52:53 | 648 | 0:10:48 | 1 | jidoka op90 | 2022-11-29 00:00:00 | 03:28:51 | 2022-11-29 00:00:00 | 07:39:39
 |  |  |  |  |  |  |  |  | Quality* | 2022-11-29 19:47:30 | 2022-11-29 20:04:13 | 2022-11-29 21:52:31 | 1003 | 0:16:43 | 1 | implementation of new cvi, educating line | 2022-11-29 00:00:00 | 19:47:30 | 2022-11-29 00:00:00 | 20:04:13
 |  |  |  |  |  |  |  |  | Quality* | 2022-11-30 05:20:01 | 2022-11-30 05:27:06 | 2022-11-30 05:33:09 | 425 | 0:07:05 | 1 | op50  found the wrong damper in with the 0183 dampers had to sort through them real quick to make sure it was the only one | 2022-11-30 00:00:00 | 05:20:01 | 2022-11-30 00:00:00 | 05:27:06
 |  |  |  |  |  |  |  |  | Line Waiting | 2022-11-28 07:10:53 | 2022-11-28 07:11:37 | 2022-11-28 07:11:37 | 44 | 0:00:44 | 1
 |  |  |  |  |  |  |  |  | Shift Change | 2022-11-28 22:55:16 | 2022-11-28 23:04:51 | 2022-11-28 23:03:39 | 575 | 0:09:35 | 1 |  | 2022-11-28 00:00:00 | 22:55:16 | 2022-11-28 00:00:00 | 23:04:51
 |  |  |  |  |  |  |  |  | Shift Change | 2022-11-29 07:00:00 | 2022-11-29 07:03:20 | 2022-11-29 08:31:52 | 200 | 0:03:20 | 1 |  | 2022-11-29 00:00:00 | 07:00:00 | 2022-11-29 00:00:00 | 07:03:20
 |  |  |  |  |  |  |  |  | Mechanical Failure | 2022-11-29 15:00:00 | 2022-11-29 15:02:28 | 2022-11-29 21:50:02 | 148 | [NAME] | 1 |  | 2022-11-29 00:00:00 | 15:00:00 | 2022-11-29 00:00:00 | 15:02:28
 |  |  |  |  |  |  |  |  | Shift Change | 2022-11-29 22:55:06 | 2022-11-29 23:05:49 | 2022-11-30 00:05:52 | 643 | 0:10:43 | 1 |  | 2022-11-29 00:00:00 | 22:55:06 | 2022-11-29 00:00:00 | 23:05:49
 |  |  |  |  |  |  |  |  | Shift Change | 2022-11-30 06:59:35 | 2022-11-30 07:01:31 | 2022-11-30 07:26:46 | 116 | 0:01:56 | 1 |  | 2022-11-30 00:00:00 | 06:59:35 | 2022-11-30 00:00:00 | 07:01:31