Create a report where we can choose how attendance is calculated. We use timeslot reservations and some facilities are in 30-minute timeslots. Sportsman duplicates attendance for a two hour reservation 4 times due to 30-minute timeslot. If it is a single individual reserving consecutive timeslots, I only want to count the attendance one time. For a one month report for 6 tennis courts there is about 1600 rows of data in Excel and you can't eliminate duplicates because people reserve multiple times a month. If there is another way to do this in Excel, somebody please tell me.