Hi, Just a quick question that I'm hoping someone could help out with please-
I am wanting to keep track of student's hours of attendance as a percentage. Each class is 5 hours long and over the course there are a total of 12 classes. What I would like to do is have a formula so the percentage is calculated from the new total every week. It's a little hard to explain so an example -
class1 a student attends for 5/5hrs so the % cell would output 100% next week the student shows up for 4/5hrs so I want the percentage cell to output
90% if the 3rd class they don't show up at all i.e 0/5hr I want the % to show 60%
This seems easy enough but how do I make sure that every week the percentage is calculated by the new total amount of class time? The solution may be more simple than I think but I've tried a few things and haven't been able to work it out yet so that it all works properly. Any helpwould be much appreciated.
Bookmarks