Mean Average total timesheet hours per team

Hi folks!!

What I want to do is have the total hours in a timesheet grouped up by a Team.
Then have an average of that amount by the number of people in that team. So that it spits out something like, Team a 42 hrs, Team B 47 hours. Etc etc.

I was trying to group the hours by home team, but then the average was calculating the average of the individual hours entered, so it was showing 2.66 and such as each individual input of hours was around 1-4 at a time.

It may be something that it cant do as a native report. I got quite far in getting it to add up all the total hours in a timesheet for a team, but it cant average by the amount of users in the team, (at least it wasn’t a standard option).

Any help as always appreciated!