Good Looking Bloke
Registered User.
- Local time
- Today, 21:58
- Joined
- Oct 15, 2019
- Messages
- 30
So I have a time in for visitors.
The visitors stay for an average of 45 minutes.
So if they arrive at 8.00 they leave on average at 8.45.
I am trying to count something like:
Betty arrives at 8.00 (assumed to leave at 8.45)
Wilma arrives at 8.15 (assumed to leave at 9.00)
Linda arrives at 8.30 (assumed to leave at 9.15)
Therefore the answer I am wanting to calculate is:
Visitors on site at:
8.00 1
8.15 2
8.30 3
8.45 2
9.00 1
etc
I am broadly thinking I would start with the time in and calculate the time out using a dateadd for 45 minuets. But then how to count them from there? Sorry brain stopped working about morning tea time today.
Thanks
The visitors stay for an average of 45 minutes.
So if they arrive at 8.00 they leave on average at 8.45.
I am trying to count something like:
Betty arrives at 8.00 (assumed to leave at 8.45)
Wilma arrives at 8.15 (assumed to leave at 9.00)
Linda arrives at 8.30 (assumed to leave at 9.15)
Therefore the answer I am wanting to calculate is:
Visitors on site at:
8.00 1
8.15 2
8.30 3
8.45 2
9.00 1
etc
I am broadly thinking I would start with the time in and calculate the time out using a dateadd for 45 minuets. But then how to count them from there? Sorry brain stopped working about morning tea time today.
Thanks