Hi all - I am really stuck on this one. I am not sure how to set it out on a sheet, maybe in a calendar type view (31 days) but i need to calculate how many times door number 34 is accessed and then if it was accessed and followed by door number 41 access provide the time (number of minutes/hours) between the two time stamps.
but there will be multiple entries per day. so somehow i need to sum the first 34 and 41 then sum the next 34 and 41 on the same date etc etc.... hope that makes sense, i have no clue how to explain it haha.
the table below starts in Column A and goes to Column G
TIA if anyone is game enough to try.
but there will be multiple entries per day. so somehow i need to sum the first 34 and 41 then sum the next 34 and 41 on the same date etc etc.... hope that makes sense, i have no clue how to explain it haha.
the table below starts in Column A and goes to Column G
TIA if anyone is game enough to try.
05/06/2020 | 7:20 | Button Adrian | Button | Adrian | 34 | Main Office Lunch Room through 34 |
05/06/2020 | 7:48 | Button Adrian | Button | Adrian | 34 | Main Office Lunch Room through 34 |
05/06/2020 | 7:49 | Button Adrian | Button | Adrian | 41 | Factory Entry through 41 |
05/06/2020 | 9:06 | Button Adrian | Button | Adrian | 34 | Main Office Lunch Room through 34 |
05/06/2020 | 9:36 | Button Adrian | Button | Adrian | 41 | Factory Entry through 41 |
05/06/2020 | 11:24 | Button Adrian | Button | Adrian | 34 | Main Office Lunch Room through 34 |
05/06/2020 | 13:24 | Button Adrian | Button | Adrian | 34 | Main Office Lunch Room through 34 |
05/06/2020 | 13:49 | Button Adrian | Button | Adrian | 41 | Factory Entry through 41 |