Spreadsheet: 480163d1473799215-if-formula-with-time-time
Sheet: Sheet1

 |  | CONDITONS
 |  | Between 5am and 5 pm - Shift 1
 |  | Outside of this  - Shift 2
 | 2016-07-23 18:41:01
 | 2016-07-23 18:41:46
 | 2016-07-23 18:43:39
 | 2016-07-23 18:59:42
 | 2016-07-23 19:04:04
 | 2016-07-23 19:05:05
 | 2016-07-23 19:05:36
 | 2016-07-24 06:29:04
 | 2016-07-24 06:30:28
 | 2016-07-24 06:31:35
 | 2016-07-24 06:32:41
 | 2016-07-24 06:33:25
 | 2016-07-24 06:34:16
 | 2016-07-24 06:34:55
 | 2016-07-24 18:44:35
 | 2016-07-24 18:45:05
 | 2016-07-24 18:45:40
 | 2016-07-24 18:50:22
 | 2016-07-24 18:51:07
 | 2016-07-24 18:51:28
 | 2016-07-24 18:51:51
 | 2016-07-25 06:17:30
 | 2016-07-25 06:18:01
 | 2016-07-25 06:18:33
 | 2016-07-25 06:19:59
 | 2016-07-25 06:20:30
 | 2016-07-25 06:21:28
 | 2016-07-25 06:22:03
 | 2016-07-26 06:37:54
 | 2016-07-26 06:38:17
 | 2016-07-26 06:38:37
 | 2016-07-29 18:27:03
 | 2016-07-29 18:27:29
 | 2016-07-29 18:28:01
 | 2016-07-29 18:29:07
 | 2016-07-29 18:30:03
 | 2016-07-29 18:30:47
 | 2016-07-29 18:31:19
 | 2016-07-30 18:08:57
 | 2016-07-30 18:09:29
 | 2016-07-30 18:09:59
 | 2016-07-30 18:10:46
 | 2016-07-30 18:11:17
 | 2016-07-30 18:12:00
 | 2016-07-30 18:12:37
 | 2016-07-31 19:02:34
 | 2016-07-31 19:03:01
 | 2016-07-31 19:03:27
 | 2016-08-01 06:38:02
 | 2016-08-01 06:38:36
 | 2016-08-01 06:39:04
 | 2016-08-01 06:40:00
 | 2016-08-01 06:40:31
 | 2016-08-01 06:42:10
 | 2016-08-01 06:42:43
 | 2016-08-02 19:01:56
 | 2016-08-02 19:02:20
 | 2016-08-02 19:02:45
 | 2016-08-03 06:53:54
 | 2016-08-03 06:54:33
 | 2016-08-03 06:55:10
 | 2016-08-03 06:56:06
 | 2016-08-03 06:56:36
 | 2016-08-03 06:57:15
 | 2016-08-03 06:57:57
 | 2016-08-04 07:00:32
 | 2016-08-04 07:00:53
 | 2016-08-04 07:01:14
 | 2016-08-05 06:41:31
 | 2016-08-05 06:41:53
 | 2016-08-05 06:42:16
 | 2016-08-07 18:38:33
 | 2016-08-07 18:39:09
 | 2016-08-07 18:39:48
 | 2016-08-07 18:40:32
 | 2016-08-07 18:41:07
 | 2016-08-07 18:41:48
 | 2016-08-07 18:42:16
 | 2016-08-07 18:42:56
 | 2016-08-17 18:44:35
 | 2016-08-17 18:44:56
 | 2016-08-17 18:45:11
 | 2016-08-17 18:45:31
 | 2016-08-17 18:45:53
 | 2016-08-17 18:46:17
 | 2016-08-17 18:46:34
 | 2016-08-18 06:40:55
 | 2016-08-18 06:41:31
 | 2016-08-18 06:42:16
 | 2016-08-18 06:43:15
 | 2016-08-18 06:43:50
 | 2016-08-18 06:44:27
 | 2016-08-18 06:45:02
 | 2016-08-18 18:39:33
 | 2016-08-18 18:39:49
 | 2016-08-18 18:40:10
 | 2016-08-18 18:40:27
 | 2016-08-18 18:40:48
 | 2016-08-18 18:41:10
 | 2016-08-18 18:41:27
 | 2016-08-19 06:32:53
 | 2016-08-19 06:33:27
 | 2016-08-19 06:34:14
 | 2016-08-19 06:34:52
 | 2016-08-19 06:35:26
 | 2016-08-19 06:36:01
 | 2016-08-19 06:36:35
 | 2016-08-24 18:48:39
 | 2016-08-24 18:49:11
 | 2016-08-24 18:49:39
 | 2016-08-24 18:50:38
 | 2016-08-24 18:51:15
 | 2016-08-24 18:51:43
 | 2016-08-29 09:51:05
 | 2016-08-31 18:49:46
 | 2016-08-31 18:50:13
 | 2016-08-31 18:50:39
 | 2016-08-31 18:51:09
 | 2016-08-31 18:51:35
 | 2016-08-31 18:52:00
 | 2016-08-31 18:52:26
 | 2016-08-31 18:53:19
 | 2016-09-02 18:48:57
 | 2016-09-02 18:49:17
 | 2016-09-02 18:49:36
 | 2016-09-02 18:49:53
 | 2016-09-02 18:50:24
 | 2016-09-02 18:50:49
 | 2016-09-02 18:51:07
 | 2016-09-03 19:30:56
 | 2016-09-03 19:36:30
 | 2016-09-03 19:37:13
 | 2016-09-04 06:45:04
 | 2016-09-04 06:45:33
 | 2016-09-04 06:45:58
 | 2016-09-04 06:46:28
 | 2016-09-04 06:47:02
 | 2016-09-04 06:47:38
 | 2016-09-04 06:48:28
 | 2016-09-04 18:51:03
 | 2016-09-04 18:51:45
 | 2016-09-04 18:52:32
 | 2016-09-05 18:51:33
 | 2016-09-05 18:52:53
 | 2016-09-05 18:53:26
 | 2016-09-06 06:31:31
 | 2016-09-06 06:32:12
 | 2016-09-06 06:33:04
 | 2016-09-06 06:34:01
 | 2016-09-06 06:34:28
 | 2016-09-06 06:35:21
 | 2016-09-06 06:35:54
 | 2016-09-06 06:36:24
 | 2016-09-07 06:37:05
 | 2016-09-07 06:38:11
 | 2016-09-07 06:38:33
 | 2016-09-08 06:55:10
 | 2016-09-08 06:56:08
 | 2016-09-08 18:46:08
 | 2016-09-08 18:46:33
 | 2016-09-08 18:47:01
 | 2016-09-08 18:47:34
 | 2016-09-08 18:47:58
 | 2016-09-08 18:48:19
 | 2016-09-08 18:48:46
 | 2016-09-08 18:49:14
 | 2016-09-10 18:46:07
 | 2016-09-10 18:46:56
 | 2016-09-10 18:47:33
 | 2016-09-10 18:48:19
 | 2016-09-10 18:48:57
 | 2016-09-10 18:49:20
 | 2016-09-10 18:49:43
 | 2016-09-10 18:50:16
 | 2016-09-10 18:50:49
 | 2016-09-11 06:13:30
 | 2016-09-11 06:13:55
 | 2016-09-11 06:14:19
 | 2016-09-11 06:14:47
 | 2016-09-11 06:15:13
 | 2016-09-11 06:15:34
 | 2016-09-11 06:16:05
 | 2016-09-11 18:37:50
 | 2016-09-11 18:38:18
 | 2016-09-11 18:38:40
 | 2016-09-11 18:39:08
 | 2016-09-11 18:39:36
 | 2016-09-11 18:40:05
 | 2016-09-11 18:40:30
 | 2016-09-11 18:41:03
 | 2016-09-11 18:41:31
 | 2016-09-11 18:42:00
 | 2016-09-12 06:36:34
 | 2016-09-12 06:37:00
 | 2016-09-12 06:37:43
 | 2016-09-12 06:38:11
 | 2016-09-12 06:38:35
 | 2016-09-12 06:38:58
 | 2016-09-12 06:39:41
 | 2016-09-12 06:40:11
 | 2016-09-13 06:31:00
 | 2016-09-13 06:31:32
 | 2016-09-13 06:31:59
 | 2016-09-13 06:32:28
 | 2016-09-13 06:32:58
 | 2016-09-13 06:33:25
 | 2016-09-13 06:33:51
 | 2016-09-13 06:34:23
 | 2016-09-13 06:34:49
 | 2016-09-13 18:00:24
 | 2016-09-13 18:02:03
 | 2016-07-07 18:53:12
 | 2016-07-08 08:31:37
 | 2016-07-08 08:32:37
 | 2016-07-08 08:33:20
 | 2016-07-08 08:34:06
 | 2016-07-08 08:34:52
 | 2016-07-08 08:35:30
 | 2016-07-08 08:36:11
 | 2016-07-08 08:36:59
 | 2016-07-08 08:38:00
 | 2016-07-11 12:04:30
 | 2016-07-11 12:46:31
 | 2016-07-19 18:29:28
 | 2016-07-19 18:30:27
 | 2016-07-19 18:31:16
 | 2016-07-19 18:32:22
 | 2016-07-19 18:33:14
 | 2016-07-19 18:34:01
 | 2016-07-19 18:34:30
 | 2016-07-19 18:35:06