mmopulencia
New Member
- Joined
- Feb 19, 2013
- Messages
- 30
Hello Again!
HI i seem to be stuck in a rut and cant get myself out of this problem, what im trying to do is count the heads staffed in a particular interval based on their time log.
Example on sheet 1 i have .
<tbody>
</tbody>
and then on sheet 2 i have
<tbody>
</tbody>
and the list goes on till 11:45 pm.
Thank you for your help in advance <3
HI i seem to be stuck in a rut and cant get myself out of this problem, what im trying to do is count the heads staffed in a particular interval based on their time log.
Example on sheet 1 i have .
Name | date | Start | End |
Mike | 09/19/2017 | 12:16 am | 3:35 am |
John | 09/19/2017 | 1:39 am | 2:00 am |
<tbody>
</tbody>
and then on sheet 2 i have
name | date | 12:00 am | 12:15 am | 12:30 am | 12:45 am | 1:00 am | 1:15 am | 1:30 am | 1:45 am | 2:00 am | 2:15 am | 2:30 am | 2:45 am | 3:00 am | 3:15 am | 3:30 am | 3:45 am | 4:00 am | ||||||
Mike | 09/19/2017 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |||||||||
John | 09/19/2017 | 1 | 1 |
<tbody>
</tbody>
and the list goes on till 11:45 pm.
Thank you for your help in advance <3