I was asked to total the number of hours each employee spent taking each class.
Some classes span a couple of days or a week - most are just a few short hours. What the requestor wants is a list of the student names, then the classes he/she took listed (once for each class) and the total number of hours he/she spent in those classes. I'm at a loss. I made a calculation to show the number of hours in each class. But, when classes span more than a day, I get confused. And, when I try to group the classes (for those people who took the class multiple times), then all my calculations are wrong. Can you help me please?