Preparing Weekly attendance Percentage of Agents

Hi,

I want to prepare a attendance tracker for March 08. Following are the points i want to include in that tracker

1) I will be having data of around 60 Employees which are divided in 4 Teams(approx 15 in 1 team). i want weekly attendance percentage of each and every single Employee as well as the weekly attendance percentage of 4 teams also. the attendance will be inputed by me everyday.

2)i will marked the present employees as "P" and Absent employees as "A". so which calculating the weekly % this criteria must be kept in mind.


Please help me in this problem. i have attached an Excel sheet of what i exactly want.

Thanks a ton.

Hi,

I want to prepare a attendance tracker for March 08. Following are the points i want to include in that tracker

1) I will be having data of around 60 Employees which are divided in 4 Teams(approx 15 in 1 team). i want weekly attendance percentage of each and every single Employee as well as the weekly attendance percentage of 4 teams also. the attendance will be inputed by me everyday.

2)i will marked the present employees as "P" and Absent employees as "A". so which calculating the weekly % this criteria must be kept in mind.


Please help me in this problem. i have attached an Excel sheet of what i exactly want.

Thanks a ton.

Hi,

I want to prepare a attendance tracker for March 08. Following are the points i want to include in that tracker

1) I will be having data of around 60 Employees which are divided in 4 Teams(approx 15 in 1 team). i want weekly attendance percentage of each and every single Employee as well as the weekly attendance percentage of 4 teams also. the attendance will be inputed by me everyday.

2)i will marked the present employees as "P" and Absent employees as "A". so which calculating the weekly % this criteria must be kept in mind.


Please help me in this problem. i have attached an Excel sheet of what i exactly want.

Thanks a ton.

Thanks 4 making me know