I need a calculation of the time spent in a room.
I have eg 2 or more entrances and so many exits to and from a room. I have an access controller at each door both at the entrance and at the exit in both directions (defined in the event_point_id field. So I have a record of each entry and exit...