Spreadsheet: 278314d1384697997-allocating-a-staff-based-on-the-time-they-finish-task-keepin-in-mind-start-time-of-task-excel-help
Sheet: Sheet1 (2)

Work Begins | Work is completed | Staff # to be allocated here |  |  |  |  |  |  | Staff #
2013-10-07 23:38:00 | 2013-10-07 23:57:00 |  |  |  |  |  |  |  | 1
2013-10-08 00:02:00 | 2013-10-08 00:25:36 |  |  |  |  |  |  |  | 2
2013-10-08 00:12:00 | 2013-10-08 00:36:12 |  |  |  |  |  |  |  | 3
2013-10-08 00:16:00 | 2013-10-08 00:22:42 |  |  |  |  |  |  |  | 4
2013-10-08 00:20:00 | 2013-10-08 00:30:48 |  |  |  |  |  |  |  | 5
2013-10-08 00:27:00 | 2013-10-08 00:36:36 |  |  |  |  |  |  |  | 6
2013-10-08 00:30:00 | 2013-10-08 00:49:48 |  |  |  |  |  |  |  | 7
2013-10-08 00:31:00 | 2013-10-08 00:37:24 |  |  |  |  |  |  |  | 8
2013-10-08 00:39:00 | 2013-10-08 01:01:36 |  |  |  |  |  |  |  | 9
2013-10-08 00:40:00 | 2013-10-08 00:50:36 |  |  |  |  |  |  |  | 10
2013-10-08 00:44:00 | 2013-10-08 00:53:54 |  |  |  |  |  |  |  | 11
2013-10-08 00:47:00 | 2013-10-08 00:53:06 |  |  |  |  |  |  |  | 12
2013-10-08 00:50:00 | 2013-10-08 01:01:00 |  |  |  |  |  |  |  | 13
2013-10-08 00:53:00 | 2013-10-08 01:17:00 |  |  |  |  |  |  |  | 14
2013-10-08 00:58:00 | 2013-10-08 01:04:24
2013-10-08 00:59:00 | 2013-10-08 01:06:30
2013-10-08 01:01:00 | 2013-10-08 01:25:48
2013-10-08 01:02:00 | 2013-10-08 01:22:24
2013-10-08 01:04:00 | 2013-10-08 01:13:12
2013-10-08 01:04:00 | 2013-10-08 01:19:00
2013-10-08 01:06:00 | 2013-10-08 01:14:54
2013-10-08 01:08:00 | 2013-10-08 01:26:54
2013-10-08 01:12:00 | 2013-10-08 01:31:42
2013-10-08 01:14:00 | 2013-10-08 01:35:30
2013-10-08 01:16:00 | 2013-10-08 01:29:18
2013-10-08 01:18:00 | 2013-10-08 01:39:48
2013-10-08 01:18:00 | 2013-10-08 01:42:54
2013-10-08 01:31:00 | 2013-10-08 01:50:36
2013-10-08 01:31:00 | 2013-10-08 01:46:48
2013-10-08 01:44:00 | 2013-10-08 01:51:48
2013-10-08 01:45:00 | 2013-10-08 02:09:18
2013-10-08 01:46:00 | 2013-10-08 01:55:48
2013-10-08 01:52:00 | 2013-10-08 02:03:00
2013-10-08 02:11:00 | 2013-10-08 02:28:30
2013-10-08 02:17:00 | 2013-10-08 02:36:12
2013-10-08 02:21:00 | 2013-10-08 02:36:54
2013-10-08 03:20:00 | 2013-10-08 03:41:24
2013-10-08 03:29:00 | 2013-10-08 03:49:42
2013-10-08 03:36:00 | 2013-10-08 03:45:00
2013-10-08 03:44:00 | 2013-10-08 04:04:12
2013-10-08 03:47:00 | 2013-10-08 03:56:30
2013-10-08 03:55:00 | 2013-10-08 04:16:18
2013-10-08 03:58:00 | 2013-10-08 04:04:30
2013-10-08 04:00:00 | 2013-10-08 04:18:42
2013-10-08 04:01:00 | 2013-10-08 04:19:36
2013-10-08 04:22:00 | 2013-10-08 04:42:06
2013-10-08 04:36:00 | 2013-10-08 04:54:00
2013-10-08 04:38:00 | 2013-10-08 04:48:18
2013-10-08 04:41:00 | 2013-10-08 04:56:24
2013-10-08 04:47:00 | 2013-10-08 04:56:00
2013-10-08 04:48:00 | 2013-10-08 04:55:48
2013-10-08 04:51:00 | 2013-10-08 05:02:36
2013-10-08 04:51:00 | 2013-10-08 05:05:36
2013-10-08 04:59:00 | 2013-10-08 05:24:00
2013-10-08 05:00:00 | 2013-10-08 05:10:36
2013-10-08 05:03:00 | 2013-10-08 05:08:18
2013-10-08 05:03:00 | 2013-10-08 05:25:30
2013-10-08 05:07:00 | 2013-10-08 05:18:42
2013-10-08 05:17:00 | 2013-10-08 05:37:48
2013-10-08 05:18:00 | 2013-10-08 05:31:06
2013-10-08 05:23:00 | 2013-10-08 05:47:12
2013-10-08 05:26:00 | 2013-10-08 05:32:12
2013-10-08 05:30:00 | 2013-10-08 05:37:36
2013-10-08 05:38:00 | 2013-10-08 05:57:30
2013-10-08 05:41:00 | 2013-10-08 06:00:36
2013-10-08 05:44:00 | 2013-10-08 05:52:30
2013-10-08 05:46:00 | 2013-10-08 06:02:48
2013-10-08 05:54:00 | 2013-10-08 06:13:24
2013-10-08 05:56:00 | 2013-10-08 06:18:48
2013-10-08 05:57:00 | 2013-10-08 06:11:00
2013-10-08 05:58:00 | 2013-10-08 06:22:42
2013-10-08 06:07:00 | 2013-10-08 06:13:48
2013-10-08 06:09:00 | 2013-10-08 06:18:36
2013-10-08 06:09:00 | 2013-10-08 06:22:24
2013-10-08 06:13:00 | 2013-10-08 06:37:24
2013-10-08 06:16:00 | 2013-10-08 06:37:24
2013-10-08 06:18:00 | 2013-10-08 06:25:30
2013-10-08 06:22:00 | 2013-10-08 06:40:24
2013-10-08 06:26:00 | 2013-10-08 06:44:18
2013-10-08 06:31:00 | 2013-10-08 06:39:06
2013-10-08 06:31:00 | 2013-10-08 06:41:30
2013-10-08 06:35:00 | 2013-10-08 06:57:30
2013-10-08 06:37:00 | 2013-10-08 06:42:36
2013-10-08 06:41:00 | 2013-10-08 06:59:36
2013-10-08 06:45:00 | 2013-10-08 06:52:18
2013-10-08 06:45:00 | 2013-10-08 06:55:48
2013-10-08 06:48:00 | 2013-10-08 06:53:18
2013-10-08 06:49:00 | 2013-10-08 06:55:42
2013-10-08 06:49:00 | 2013-10-08 07:07:24
2013-10-08 06:51:00 | 2013-10-08 07:00:54
2013-10-08 06:58:00 | 2013-10-08 07:23:00
2013-10-08 06:59:00 | 2013-10-08 07:12:48
2013-10-08 07:02:00 | 2013-10-08 07:11:48
2013-10-08 07:03:00 | 2013-10-08 07:11:18
2013-10-08 07:07:00 | 2013-10-08 07:30:24
2013-10-08 07:18:00 | 2013-10-08 07:32:42
2013-10-08 07:24:00 | 2013-10-08 07:39:00
2013-10-08 07:29:00 | 2013-10-08 07:47:30
2013-10-08 07:31:00 | 2013-10-08 07:55:24
2013-10-08 07:38:00 | 2013-10-08 08:02:18
2013-10-08 07:43:00 | 2013-10-08 07:52:54
2013-10-08 07:53:00 | 2013-10-08 08:01:54
2013-10-08 07:57:00 | 2013-10-08 08:04:00
2013-10-08 08:11:00 | 2013-10-08 08:19:36
2013-10-08 08:16:00 | 2013-10-08 08:28:42
2013-10-08 08:18:00 | 2013-10-08 08:26:00
2013-10-08 08:20:00 | 2013-10-08 08:38:00
2013-10-08 08:22:00 | 2013-10-08 08:29:54
2013-10-08 08:28:00 | 2013-10-08 08:40:18
2013-10-08 08:41:00 | 2013-10-08 08:51:12
2013-10-08 08:50:00 | 2013-10-08 09:06:42
2013-10-08 08:55:00 | 2013-10-08 09:14:48
2013-10-08 09:15:00 | 2013-10-08 09:24:48
2013-10-08 10:49:00 | 2013-10-08 10:54:30
2013-10-08 11:07:00 | 2013-10-08 11:17:12
2013-10-08 11:24:00 | 2013-10-08 11:39:06
2013-10-08 11:27:00 | 2013-10-08 11:34:36
2013-10-08 11:31:00 | 2013-10-08 11:45:30
2013-10-08 11:59:00 | 2013-10-08 12:17:00
2013-10-08 12:02:00 | 2013-10-08 12:23:18
2013-10-08 12:10:00 | 2013-10-08 12:23:30
2013-10-08 12:14:00 | 2013-10-08 12:38:36
2013-10-08 12:23:00 | 2013-10-08 12:34:54
2013-10-08 12:26:00 | 2013-10-08 12:42:00
2013-10-08 12:28:00 | 2013-10-08 12:41:06
2013-10-08 12:37:00 | 2013-10-08 12:42:06
2013-10-08 12:39:00 | 2013-10-08 12:58:36
2013-10-08 12:41:00 | 2013-10-08 12:48:30
2013-10-08 12:44:00 | 2013-10-08 13:04:54
2013-10-08 12:45:00 | 2013-10-08 13:04:30
2013-10-08 12:47:00 | 2013-10-08 12:54:36
2013-10-08 12:49:00 | 2013-10-08 13:11:06
2013-10-08 12:51:00 | 2013-10-08 13:03:48
2013-10-08 13:01:00 | 2013-10-08 13:24:24
2013-10-08 13:10:00 | 2013-10-08 13:23:18
2013-10-08 13:14:00 | 2013-10-08 13:35:24
2013-10-08 13:16:00 | 2013-10-08 13:33:18
2013-10-08 13:18:00 | 2013-10-08 13:34:48
2013-10-08 13:20:00 | 2013-10-08 13:32:18
2013-10-08 13:26:00 | 2013-10-08 13:31:12
2013-10-08 13:28:00 | 2013-10-08 13:34:42
2013-10-08 13:37:00 | 2013-10-08 13:42:06
2013-10-08 13:37:00 | 2013-10-08 13:58:42
2013-10-08 13:39:00 | 2013-10-08 14:02:30
2013-10-08 13:45:00 | 2013-10-08 13:56:12
2013-10-08 14:13:00 | 2013-10-08 14:19:36
2013-10-08 14:16:00 | 2013-10-08 14:28:36
2013-10-08 14:31:00 | 2013-10-08 14:42:36
2013-10-08 14:33:00 | 2013-10-08 14:51:36
2013-10-08 15:17:00 | 2013-10-08 15:39:48
2013-10-08 15:25:00 | 2013-10-08 15:39:06
2013-10-08 15:26:00 | 2013-10-08 15:45:18
2013-10-08 15:42:00 | 2013-10-08 16:04:18
2013-10-08 16:23:00 | 2013-10-08 16:34:54
2013-10-08 16:48:00 | 2013-10-08 17:09:48
2013-10-08 17:01:00 | 2013-10-08 17:08:54
2013-10-08 17:26:00 | 2013-10-08 17:35:42
2013-10-08 17:32:00 | 2013-10-08 17:52:00
2013-10-08 17:47:00 | 2013-10-08 18:05:06
2013-10-08 18:22:00 | 2013-10-08 18:31:24
2013-10-08 18:24:00 | 2013-10-08 18:38:24
2013-10-08 18:41:00 | 2013-10-08 18:55:48
2013-10-08 18:45:00 | 2013-10-08 18:59:30
2013-10-08 18:46:00 | 2013-10-08 19:00:54
2013-10-08 19:08:00 | 2013-10-08 19:18:36
2013-10-08 19:16:00 | 2013-10-08 19:21:30
2013-10-08 19:28:00 | 2013-10-08 19:43:24
2013-10-08 19:30:00 | 2013-10-08 19:47:24
2013-10-08 19:31:00 | 2013-10-08 19:53:48
2013-10-08 19:39:00 | 2013-10-08 19:50:48
2013-10-08 19:55:00 | 2013-10-08 20:13:00
2013-10-08 20:07:00 | 2013-10-08 20:31:30
2013-10-08 20:17:00 | 2013-10-08 20:37:24
2013-10-08 20:22:00 | 2013-10-08 20:33:48
2013-10-08 20:29:00 | 2013-10-08 20:43:12
2013-10-08 20:45:00 | 2013-10-08 21:09:48
2013-10-08 20:47:00 | 2013-10-08 20:58:54
2013-10-08 20:50:00 | 2013-10-08 21:10:18
2013-10-08 21:04:00 | 2013-10-08 21:21:30
2013-10-08 21:17:00 | 2013-10-08 21:39:54
2013-10-08 21:17:00 | 2013-10-08 21:39:42
2013-10-08 21:20:00 | 2013-10-08 21:34:36
2013-10-08 21:24:00 | 2013-10-08 21:39:24
2013-10-08 21:49:00 | 2013-10-08 22:00:30
2013-10-08 21:58:00 | 2013-10-08 22:11:54
2013-10-08 21:58:00 | 2013-10-08 22:16:54
2013-10-08 22:00:00 | 2013-10-08 22:17:18
2013-10-08 22:02:00 | 2013-10-08 22:20:36
2013-10-08 22:06:00 | 2013-10-08 22:11:42
2013-10-08 22:11:00 | 2013-10-08 22:24:24
2013-10-08 22:15:00 | 2013-10-08 22:32:12
2013-10-08 22:26:00 | 2013-10-08 22:43:48
2013-10-08 22:44:00 | 2013-10-08 22:54:18
2013-10-08 22:46:00 | 2013-10-08 23:10:54
2013-10-08 22:51:00 | 2013-10-08 23:16:00
2013-10-08 22:55:00 | 2013-10-08 23:10:18
2013-10-08 22:59:00 | 2013-10-08 23:19:42
2013-10-08 23:03:00 | 2013-10-08 23:21:24
2013-10-08 23:12:00 | 2013-10-08 23:23:24
2013-10-08 23:14:00 | 2013-10-08 23:26:00
2013-10-08 23:16:00 | 2013-10-08 23:33:54
2013-10-08 23:25:00 | 2013-10-08 23:40:00
2013-10-08 23:28:00 | 2013-10-08 23:47:12
2013-10-08 23:30:00 | 2013-10-08 23:38:24
2013-10-08 23:35:00 | 2013-10-08 23:48:30
2013-10-08 23:40:00 | 2013-10-08 23:57:48
2013-10-08 23:44:00 | 2013-10-08 23:54:54
2013-10-08 23:44:00 | 2013-10-08 23:58:54
2013-10-08 23:53:00 | 2013-10-09 00:04:42
2013-10-08 23:55:00 | 2013-10-09 00:05:36
2013-10-08 23:57:00 | 2013-10-09 00:02:06
2013-10-09 00:00:00 | 2013-10-09 00:14:00
2013-10-09 00:02:00 | 2013-10-09 00:18:30
2013-10-09 00:06:00 | 2013-10-09 00:14:24
2013-10-09 00:08:00 | 2013-10-09 00:13:54
2013-10-09 00:08:00 | 2013-10-09 00:16:30
2013-10-09 00:08:00 | 2013-10-09 00:28:42
2013-10-09 00:16:00 | 2013-10-09 00:40:42
2013-10-09 00:21:00 | 2013-10-09 00:36:24
2013-10-09 01:20:00 | 2013-10-09 01:29:36