Hi everyone,
I've got a series of data of (dates, times, doors and people) - I need to calculate how long each person has been in office per day - the complexity is that people use different accesses to enter/leave the building, and they also "come & go" so you have multiple logs. Has anyone experienced similar that they have managed to build a formula to do?
Bookmarks