Hi Guys,
I have the following times of duty for our employees. What I would like to do is count the maximum number of employees that will be on site during the day. Can someone please help me? There are different employee number for different days. Data below shows 4 of the days. The actual table is much bigger with a lot more employees.
<colgroup><col span="5"><col></colgroup><tbody>
</tbody>
Thanks and Regards
Asad
I have the following times of duty for our employees. What I would like to do is count the maximum number of employees that will be on site during the day. Can someone please help me? There are different employee number for different days. Data below shows 4 of the days. The actual table is much bigger with a lot more employees.
Start | Meal Start | Meal End | Finish | Total | Day |
03:33 | 06:27 | 07:27 | 11:44 | 07:11 | Mon,Tue,Wed |
03:45 | 07:30 | 08:16 | 12:33 | 08:02 | Mon,Tue,Wed |
03:48 | 07:48 | 08:37 | 12:47 | 08:10 | Mon,Tue,Wed |
04:03 | 06:56 | 07:41 | 11:58 | 07:10 | Mon,Tue,Wed |
04:18 | 08:30 | 09:19 | 12:12 | 07:05 | Mon,Tue,Wed |
04:33 | 08:43 | 09:33 | 13:43 | 08:20 | Mon,Tue,Wed |
05:03 | 09:21 | 10:01 | 12:59 | 07:16 | Mon,Tue,Wed |
05:10 | 09:28 | 10:15 | 13:08 | 07:11 | Mon,Tue,Wed |
05:25 | 09:47 | 10:43 | 13:36 | 07:15 | Mon,Tue,Wed |
05:40 | 10:25 | 11:25 | 14:18 | 07:38 | Mon,Tue,Wed |
05:55 | 10:10 | 11:04 | 14:02 | 07:13 | Mon,Tue,Wed |
06:03 | 10:53 | 11:53 | 16:07 | 09:04 | Mon,Tue,Wed |
06:33 | 11:14 | 12:14 | 16:33 | 09:00 | Mon,Tue,Wed |
08:18 | 11:28 | 12:28 | 16:42 | 07:24 | Mon,Tue,Wed |
08:20 | 12:38 | 13:38 | 18:01 | 08:41 | Mon,Tue,Wed |
08:50 | 13:13 | 14:13 | 18:43 | 08:53 | Mon,Tue,Wed |
09:07 | 12:17 | 13:17 | 17:40 | 07:33 | Mon,Tue,Wed |
11:34 | 14:27 | 15:23 | 19:49 | 07:19 | Mon,Tue,Wed |
11:41 | 14:44 | 15:44 | 19:57 | 07:16 | Mon,Tue,Wed |
12:30 | 15:18 | 16:05 | 20:21 | 07:04 | Mon,Tue,Wed |
12:44 | 15:37 | 16:19 | 20:37 | 07:11 | Mon,Tue,Wed |
13:19 | 16:16 | 17:15 | 21:21 | 07:03 | Mon,Tue,Wed |
13:54 | 16:50 | 17:36 | 21:51 | 07:11 | Mon,Tue,Wed |
14:15 | 18:35 | 19:17 | 22:11 | 07:14 | Mon,Tue,Wed |
15:04 | 19:23 | 20:23 | 24:21 | 08:17 | Mon,Tue,Wed |
15:53 | 20:03 | 20:53 | 24:51 | 08:08 | Mon,Tue,Wed |
16:05 | 20:23 | 21:23 | 25:21 | 08:16 | Mon,Tue,Wed |
16:20 | 20:43 | 21:43 | 25:45 | 08:25 | Mon,Tue,Wed |
16:21 | 20:53 | 21:53 | 25:52 | 08:31 | Mon,Tue,Wed |
16:35 | 21:13 | 22:13 | 24:56 | 07:21 | Mon,Tue,Wed |
19:28 | 22:33 | 23:33 | 28:00 | 07:32 | Mon,Tue,Wed |
19:48 | 22:55 | 23:55 | 28:30 | 07:42 | Mon,Tue,Wed |
19:58 | 23:46 | 24:31 | 29:05 | 08:22 | Mon,Tue,Wed |
03:33 | 07:38 | 08:25 | 11:25 | 07:05 | Thu |
03:45 | 07:31 | 08:31 | 12:49 | 08:04 | Thu |
03:48 | 07:52 | 08:37 | 12:40 | 08:07 | Thu |
04:03 | 08:13 | 09:13 | 13:25 | 08:22 | Thu |
04:18 | 07:03 | 07:43 | 11:55 | 06:57 | Thu |
04:33 | 07:24 | 08:07 | 12:30 | 07:14 | Thu |
05:19 | 09:34 | 10:25 | 14:43 | 08:33 | Thu |
05:34 | 10:07 | 11:07 | 15:21 | 08:47 | Thu |
05:41 | 08:37 | 09:25 | 13:42 | 07:13 | Thu |
05:55 | 10:25 | 11:25 | 14:24 | 07:29 | Thu |
06:09 | 10:37 | 11:37 | 16:02 | 08:53 | Thu |
06:23 | 10:55 | 11:55 | 16:20 | 08:57 | Thu |
06:44 | 11:31 | 12:31 | 16:56 | 09:12 | Thu |
07:05 | 10:10 | 10:55 | 13:49 | 05:59 | Thu |
07:19 | 12:01 | 13:01 | 17:32 | 09:13 | Thu |
07:45 | 12:31 | 13:31 | 17:55 | 09:10 | Thu |
08:50 | 13:25 | 14:25 | 18:59 | 09:09 | Thu |
09:38 | 13:45 | 14:43 | 19:08 | 08:32 | Thu |
09:56 | 14:03 | 15:01 | 19:35 | 08:41 | Thu |
10:08 | 14:31 | 15:31 | 19:50 | 08:42 | Thu |
12:02 | 14:53 | 15:53 | 20:25 | 07:23 | Thu |
13:14 | 16:11 | 17:07 | 21:21 | 07:11 | Thu |
13:32 | 17:52 | 18:46 | 24:01 | 09:35 | Thu |
13:50 | 16:47 | 17:35 | 21:51 | 07:13 | Thu |
13:56 | 16:53 | 17:42 | 20:43 | 05:58 | Thu |
14:02 | 18:20 | 19:10 | 24:21 | 09:29 | Thu |
15:32 | 19:48 | 20:33 | 25:45 | 09:28 | Thu |
15:52 | 20:19 | 04:27 | Thu | ||
16:20 | 20:30 | 21:23 | 25:21 | 08:08 | Thu |
16:27 | 20:53 | 21:53 | 25:52 | 08:25 | Thu |
16:34 | 21:13 | 22:13 | 26:05 | 08:31 | Thu |
19:28 | 22:33 | 23:33 | 28:00 | 07:32 | Thu |
19:48 | 22:55 | 23:55 | 28:30 | 07:42 | Thu |
20:48 | 24:43 | 25:43 | 29:00 | 07:12 | Thu |
<colgroup><col span="5"><col></colgroup><tbody>
</tbody>
Thanks and Regards
Asad