wrighty998
New Member
- Joined
- Jan 31, 2018
- Messages
- 35
hi,
wondering if anyone can help me solve this for work, ive assigned my drivers an id number and managed to pull there deliverys into a table, only problem is they can leave and return and leave again in the same day, each day is split into leave and return,
im trying to get each 'id' (driver) into 1 row, but times are over lapping and i can get it to desplay right,
its like mondays cells should over rule anything already in the cell, tuesdays cell over anything in the cell and so on ?? any help is appricated
<colgroup><col><col span="14"></colgroup><tbody>
</tbody>
wondering if anyone can help me solve this for work, ive assigned my drivers an id number and managed to pull there deliverys into a table, only problem is they can leave and return and leave again in the same day, each day is split into leave and return,
im trying to get each 'id' (driver) into 1 row, but times are over lapping and i can get it to desplay right,
its like mondays cells should over rule anything already in the cell, tuesdays cell over anything in the cell and so on ?? any help is appricated
id | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | |||||||
1 | 05:46 | OUT | OUT | 18:36 | ||||||||||
1 | 08:35 | OUT | OUT | 16:56 | ||||||||||
2 | 12:30 | OUT | OUT | 16:24 | ||||||||||
3 | 16:30 | OUT | OUT | OUT | OUT | 15:33 | ||||||||
3 | 05:45 | OUT | OUT | OUT | OUT | 08:28 | ||||||||
3 | 09:00 | 16:51 | ||||||||||||
4 | 06:20 | OUT | OUT | 09:23 | ||||||||||
4 | 16:30 | OUT | OUT | OUT | OUT | 13:59 | ||||||||
4 | 06:34 | 13:38 | ||||||||||||
5 | 04:01 | OUT | OUT | OUT | OUT | 09:44 | ||||||||
5 | 16:30 | OUT | OUT | OUT | OUT | 11:11 | ||||||||
6 | 05:30 | 14:22 | ||||||||||||
6 | 16:30 | OUT | OUT | 15:56 | ||||||||||
6 | 04:05 | OUT | OUT | 14:17 | ||||||||||
6 | 06:42 | 16:58 | ||||||||||||
7 | 16:30 | OUT | OUT | OUT | OUT | 14:03 | ||||||||
7 | 03:30 | OUT | OUT | 18:01 | ||||||||||
7 | 05:01 | 14:39 | ||||||||||||
8 | 04:48 | 13:48 | ||||||||||||
8 | 05:34 | OUT | OUT | 08:45 | ||||||||||
8 | 11:59 | OUT | OUT | OUT | OUT | 16:39 | ||||||||
8 | 05:48 | 10:01 | ||||||||||||
9 | 04:00 | 14:46 | ||||||||||||
9 | 16:30 | OUT | OUT | 13:38 | ||||||||||
9 | 16:30 | OUT | OUT | 19:23 | ||||||||||
10 | 04:43 | OUT | OUT | 16:55 | ||||||||||
11 | 16:30 | OUT | OUT | 11:04 | ||||||||||
11 | 14:06 | OUT | OUT | OUT | OUT | 10:15 | ||||||||
12 | 04:53 | OUT | OUT | OUT | OUT | 10:02 | ||||||||
13 | 04:00 | 17:13 | ||||||||||||
13 | 05:32 | OUT | OUT | OUT | OUT | 11:05 | ||||||||
14 | 04:57 | 15:20 | ||||||||||||
14 | 16:30 | OUT | OUT | 14:39 | ||||||||||
15 | 04:22 | 14:53 | ||||||||||||
15 | 05:24 | 10:26 | ||||||||||||
15 | 05:02 | OUT | OUT | OUT | OUT | 10:58 | ||||||||
16 | 04:04 | OUT | OUT | 11:21 | ||||||||||
16 | 04:50 | 13:42 | ||||||||||||
17 | 05:24 | 10:26 | ||||||||||||
18 | 16:30 | OUT | OUT | OUT | OUT | OUT | OUT | 23:21 | ||||||
19 | 04:00 | 17:37 | ||||||||||||
19 | 16:30 | OUT | OUT | 15:42 | ||||||||||
19 | 16:30 | OUT | OUT | 18:11 | ||||||||||
20 | 16:30 | OUT | OUT | 15:05 | ||||||||||
20 | 16:30 | OUT | OUT | 15:40 | ||||||||||
20 | 16:30 | OUT | OUT | 15:05 | ||||||||||
21 | 12:30 | OUT | OUT | 16:34 | ||||||||||
21 | 04:00 | 18:42 | ||||||||||||
21 | 14:31 | OUT | OUT | 16:53 | ||||||||||
22 | 04:00 | 20:16 | ||||||||||||
22 | 04:00 | 16:00 | ||||||||||||
23 | 04:36 | 14:19 | ||||||||||||
23 | 16:30 | OUT | OUT | 16:41 | ||||||||||
23 | 04:00 | OUT | OUT | 06:05 | ||||||||||
24 | 04:00 | OUT |
<colgroup><col><col span="14"></colgroup><tbody>
</tbody>