I would like to ask for your help to calculate the average hours it takes to complete an Assignment Task (O Draft, F Draft, DD Draft)
My source data is a timesheet. The user will input their hours and tasks. They can work on a task multiples times during the day and on multiples days.
The formula should divided the Total Hours spend on an Assignment Task by the number of different Assignment Names.

Example for F Draft:
Project Timesheet_Example.xlsm
Date / Project / Assignment Name / Course Duration / Assignment Type / Assignment Task / Total Hours
4/6/2017 / Project 2 / Assignment Blue / 30 min / IL / F Draft / 8.00
4/7/2017 / Project 2 / Assignment Indigo / 15 min / IL / F Draft / 7.00
4/8/2017 / Project 3 / Assignment Lime / 45 min / IL F Draft / 8.00
4/9/2017 / Project 3 / Assignment Lime / 45 min / IL F Draft / 9.00

Report!B8=(8+7+(8+9))/3=10.66
It's divided by 3 because there are three distinctive Assignments. My Pivot Tables uses SUM of Total Hours.
If I change it to Average of Total hours, the result is wrong. Report!B8=(((8+7)/2)+((8+9)/2))/2=8.0

Thank you