I have this problem where I am trying to find daily averages of people that check in specific time slots for the month of January , for example
Monday
8:00- 8:15 checkin: 2 need the average for this 12/1/2015-2/1/2015
8:15-8:30 checkin:3 need the average for this 12/1/2015-2/1/2015
8:30-8:45 checkin:2 need the average for this 12/1/2015-2/1/2015
Tuesday
8:00- 8:15 checkin: 2 need the average for this 12/1/2015-2/1/2015
8:15-8:30 checkin:3 need the average for this 12/1/2015-2/1/2015
8:30-8:45 checkin:2 need the average for this 12/1/2015-2/1/2015
....
3:00-3:15 checkin: 2
Wednesday
etc
etc
And so on. .
I will find the averages for each day for each time slot but how can I do this with 4,000 rows of data? the date span 1/1/2015-2/1/2015
Thanks.
Bookmarks