I'm trying to work out if there's a formula or another way of doing my problem.

Basically, I have a team of people who perform "actions" as part of their job. An action being, basically, updating this, calling that person, and just keeping all these logged on the system.

I'm trying to calculate the performance between individuals and the team average based on full time equivalent (FTE) instead of physical bodies. I'm also trying to take into account the individuals' working days (Monday to Friday)

So, for the month of September 2003, I have 22 working days.

5 employees with a FTE of 1 worked all 22 days. 1 worked 9 days and another worked 19 days.

I have two other employees. One with a FTE of 0.6 who worked 9 days and the other with an FTE of 0.4 who worked all 22 days.

So, assuming the following test data, is there any way I can count the team average by FTE taking into account days worked, or is my thinking completely wrong regarding this?

Code:
Actions     Days       FTE
500	22	1
750	22	1
350	10	1
800	22	1
300	9	0.6
350	22	0.4
400	19	1
550	22	1