Hi Guys

I want formulas that will calculate a summary of averages from the timesheet attached(actual spreadsheet has over 50,000 rows with 12 employee). My aim is to be able to see, when I expand each subtotal/month, the average hours worked per day/week/month for the month/subtotal and in the same manner as the number of counts for all employees - summarised below the table (highlighted yellow).

In other words, each subtotal will have its summary of averages below the table when I collapse it. Cells without data should be ignored in the formula

Many thanks