Forum Discussion
Allan1950
Jun 26, 2023Copper Contributor
Excel sheet percentage attendance register
Once a week I am required to record attendance for 100+/- people. I have their names down the left-hand column. The top row will include the week number but I need the last column to adjust the perce...
SergeiBaklan
Jun 26, 2023Diamond Contributor
To calculate any per cent we need to know actual value and available value.
So, how is your weekly attendance is defined - number of days/hours or per cent for the week?
How available hours/days are defined?