Hi, I have a table of data with clock times in and out of around 60 staff who use their cards to open the door. the staff can go in and out as many times as they need to. I need to calculate per person the difference of the persons first entry and last exit. thank you in advance
<tbody>
</tbody>
Date | Time | Person | position |
01-Feb-14 | 08:01 | a | In |
01-Feb-14 | 08:08 | b | In |
01-Feb-14 | 16:01 | a | Out |
01-Feb-14 | 16:02 | b | Out |
02-Feb-14 | 08:02 | c | In |
02-Feb-14 | 08:03 | d | In |
02-Feb-14 | 16:30 | c | Out |
02-Feb-14 | 16:31 | d | Out |
03-Feb-14 | 08:05 | e | In |
03-Feb-14 | 08:06 | f | In |
03-Feb-14 | 16:40 | e | Out |
03-Feb-14 | 16:45 | f | Out |
<tbody>
</tbody>