Math Is Fun Forum

Pretty difficult to explain.. i'll try,  we have a resource schedule that uses decimalised hour/mins to work out headcount budget to cover what is required for daily tasks, each task performed has a timing against so we know how long they have spent working on a task based on the volumes they have processed,  I then take this value and then divide by the total hours worked, 100% value means they have worked as expected lower than 100% means they are not performing, above 100% working above objectives. I need to collate this daily info into a weekly table and work out an average for that week,  the same for the monthly. the monthly values will then be added to a yearly table to produce a yr to date average. Since I've been told you cannot average percentage values - I'm a little stuck