Spreadsheet: 759438d1639541695-finding-an-error-in-a-complex-if-statement-payef
Sheet: Data

 | Start | End | Work | Report | Bonus | Straight | Over
 | 04:50:00 | 07:30:00 |  |  |  | 8
 |  | 08:23:00 |  |  |  |  |  | False
 | 11:05:00 | 15:51:00
 | 05:10:00 | 09:12:00
 | 11:04:00 | 16:04:00
 | 05:10:00 | 07:30:00 |  |  |  | 7.75
 |  | 08:22:00 |  |  |  |  |  | True
 | 11:24:00 | 16:28:00
 | 05:17:00 | 07:26:00
 |  | 08:03:00
 | 10:30:00 | 16:30:00
 | 05:20:00 | 09:27:00
 | 11:05:00 | 16:43:00
 | 05:20:00 | 07:24:00
 |  | 08:02:00
 | 11:40:00 | 17:53:00
 | 05:22:00 | 07:06:00
 |  | 08:02:00
 | 11:40:00 | 17:43:00
 | 05:24:00 | 11:29:00
 | 14:33:00 | 16:40:00
 | 05:30:00 | 07:10:00
 |  | 08:02:00
 | 11:30:00 | 18:06:00 |  |  |  |  |  | False
 | 05:30:00 | 09:22:00
 | 13:50:00 | 18:28:00
 | 05:30:00 | 08:37:00 |  |  |  | 8
 | 11:50:00 | 18:20:00 |  |  |  |  |  | False
 | 05:37:00 | 09:34:00
 | 11:30:00 | 18:05:00
 | 05:46:00 | 09:40:00
 | 14:22:00 | 18:52:00
 | 05:48:00 | 09:47:00
 | 13:25:00 | 18:47:00
 | 05:50:00 | 11:17:00 |  |  |  | 8
 | 14:08:00 | 16:16:00 |  |  |  |  |  | False
 | 05:52:00 | 09:37:00 |  |  |  | 8
 | 12:57:00 | 18:44:00 |  |  |  |  |  | False
 | 05:57:00 | 10:20:00
 | 14:48:00 | 18:47:00
 | 06:00:00 | 10:07:00
 | 14:42:00 | 18:52:00
 | 16:00:00
 | 06:03:00 | 10:05:00
 | 14:42:00 | 18:55:00
 | 15:52:00
 | 06:05:00 | 11:09:00
 | 14:09:00 | 17:12:00
 | 06:05:00 | 10:27:00
 | 14:42:00 | 18:57:00
 | 15:36:00 | 18:57:00
 | 14:42:00 | 19:39:00
 | 15:36:00 | 19:39:00
 | 06:18:00 | 10:54:00 |  |  |  | 7.5
 | 14:35:00 | 19:13:00 |  |  |  |  |  | True
 | 06:32:00 | 13:00:00
 | 15:00:00 | 16:55:00
 | 06:40:00 | 12:51:00
 | 15:20:00 | 17:35:00
 | 07:00:00 | 11:42:00
 | 14:32:00 | 19:42:00
 | 07:03:00 | 14:09:00
 | 18:26:00 | 19:30:00
 | 07:10:00 | 11:52:00
 | 14:45:00 | 19:48:00
 | 07:20:00 | 13:31:00
 | 15:40:00 | 20:03:00
 | 07:30:00 | 10:30:00 |  |  |  | 8
 | 13:47:00 | 20:13:00 |  |  |  |  |  | False
 | 07:40:00 | 09:56:00 |  |  |  | 8
 | 13:17:00 | 20:30:00 |  |  |  |  |  | False
 | 11:38:00 | 12:42:00
 | 13:25:00 | 20:28:00
 | 03:53:00 | 08:37:00 |  |  |  | 8
 | 09:50:00 | 12:39:00 |  |  |  |  |  | False
 | 09:50:00 | 14:20:00
 | 03:56:00 | 09:17:00
 | 10:50:00 | 13:19:00
 | 04:25:00 | 08:40:00
 | 11:30:00 | 16:14:00
 | 04:30:00 | 08:39:00 |  |  |  | 8
 | 10:30:00 | 13:59:00 |  |  |  |  |  | False
 | 04:36:00 | 09:08:00 |  |  |  | 8
 | 10:45:00 | 13:49:00 |  |  |  |  |  | False
 | 04:58:00 | 06:43:00
 | 07:30:00 | 13:47:00
 | 05:00:00 | 08:25:00 |  |  |  | 8
 | 11:45:00 | 16:33:00 |  |  |  |  |  | False
 | 09:49:00 | 16:33:00
 | 05:05:00 | 09:39:00 |  |  |  | 8
 | 11:05:00 | 14:09:00 |  |  |  |  |  | False
 | 05:28:00 | 10:12:00 |  |  |  | 8
 | 13:23:00 | 16:53:00 |  |  |  |  |  | False
 | 05:30:00 | 12:27:00
 | 15:10:00 | 16:15:00
 | 05:35:00 | 09:33:00
 | 12:05:00 | 16:14:00
 | 05:49:00 | 12:53:00
 | 15:10:00 | 16:07:00
 | 05:50:00 | 09:54:00
 | 12:43:00 | 17:07:00
 | 06:00:00 | 10:59:00 |  |  |  | 7.75
 | 14:40:00 | 17:21:00 |  |  |  |  |  | True
 | 06:01:00 | 10:19:00
 | 14:35:00 | 17:59:00
 | 06:06:00 | 11:08:00 |  |  |  | 8
 | 14:30:00 | 17:48:00 |  |  |  |  |  | False
 | 06:10:00 | 10:09:00 |  |  |  | 8
 | 13:30:00 | 17:51:00 |  |  |  |  |  | False
 | 06:10:00 | 08:39:00
 | 11:35:00 | 17:39:00
 | 06:25:00 | 10:58:00 |  |  |  | 7.75
 | 14:45:00 | 18:46:00 |  |  |  |  |  | True
 | 06:27:00 | 08:12:00 |  |  |  | 8
 | 11:30:00 | 18:12:00 |  |  |  |  |  | False
 | 06:30:00 | 09:39:00
 | 14:00:00 | 19:19:00
 | 06:33:00 | 10:49:00
 | 14:52:00 | 18:59:00
 | 06:50:00 | 09:15:00
 | 13:35:00 | 19:39:00
 | 06:51:00 | 11:47:00 |  |  |  | 8
 | 14:55:00 | 18:32:00 |  |  |  |  |  | False
 | 07:21:00 | 08:45:00 |  |  |  | 8
 | 12:10:00 | 19:05:00 |  |  |  |  |  | False
 | 07:25:00 | 11:49:00 |  |  |  | 8
 | 15:10:00 | 19:06:00 |  |  |  |  |  | False
 | 04:30:00 | 08:05:00
 | 10:20:00 | 15:50:00
 | 07:25:00 | 11:12:00 |  |  |  | 7.75
 | 14:55:00 | 19:31:00 |  |  |  |  |  | True
 | 07:25:00 | 11:19:00 |  |  |  | 8
 | 14:34:00 | 19:35:00 |  |  |  |  |  | False
 | 07:30:00 | 10:39:00
 | 14:10:00 | 19:29:00
 | 07:40:00 | 10:19:00
 | 13:54:00 | 19:13:00
 | 04:20:00 | 11:00:00 |  |  |  | 8
 | 14:20:00 | 16:51:00 |  |  |  |  |  | False
 | 04:31:00 | 08:33:00
 | 13:10:00 | 17:32:00
 | 04:50:00 | 11:30:00
 | 12:40:00 | 16:41:00
 | 07:40:00 | 14:40:00
 | 16:22:00 | 18:52:00
 | 05:50:00 | 09:47:00
 | 11:31:00 | 17:41:00
 | 05:50:00 | 09:04:00
 | 11:00:00 | 18:12:00
 | 05:53:00 | 10:33:00
 | 12:40:00 | 17:32:00
 | 06:05:00 | 12:38:00
 | 15:10:00 | 19:11:00
 | 06:10:00 | 13:00:00
 | 14:58:00 | 17:24:00
 | 06:18:00 | 13:34:00 |  |  |  | 8
 | 16:46:00 | 19:08:00 |  |  |  |  |  | False
 | 06:50:00 | 09:24:00
 | 12:10:00 | 19:23:00
 | 06:51:00 | 11:47:00
 | 13:55:00 | 19:33:00
 | 07:00:00 | 11:40:00
 | 13:50:00 | 19:46:00
 | 07:40:00 | 13:38:00
 | 15:28:00 | 20:04:00
 | 07:10:00 | 13:08:00
 | 14:40:00 | 19:24:00
 | 06:55:00 | 09:26:00 |  |  |  | 8
 | 12:55:00 | 18:30:00 |  |  |  |  |  | False
 | 07:55:00 | 10:36:00 |  |  |  | 8 | 0.5
 | 14:15:00 | 19:40:00 |  |  |  |  |  | True
 | 13:35:00 | 16:20:00
 | 18:30:00 | 23:38:00