I have a meeting table for class start time and end time and student attendance table. I am trying to count students in a 30 min time interval in class. Problem when the class last more than hour how to count. (example: class starts at 8:05 and end at 11:00, need to count for ever interval the lass last).
