How To Calculate Productivity in Excel

[rojin.ck]

I want to calculate MTTR and Productivity for our employees. my doubt is how to calculate (actual work start date-actual end date) if employee is "Xyz". How many days he spend?

Plz help me to calculate

 

[cyrilbrd]

Hi,

Could you be more specific? Maybe an example of what you have or a example of what you would like to achieve?

 

[rojin.ck]

attaching here the detail i want to calculate if first week of April how many ticket is received and how many ticket is completed and pending. Particular day how may ticket is closed

<table border="0" cellpadding="0" cellspacing="0" width="928"><colgroup><col style="mso-width-source:userset;mso-width-alt:2523;width:52pt" width="69"> <col style="mso-width-source:userset;mso-width-alt:3291;width:68pt" width="90"> <col style="mso-width-source:userset;mso-width-alt:4205;width:86pt" width="115"> <col style="mso-width-source:userset;mso-width-alt:3291; width:68pt" span="2" width="90"> <col style="mso-width-source:userset;mso-width-alt:2486;width:51pt" width="68"> <col style="mso-width-source:userset;mso-width-alt:3291; width:68pt" span="2" width="90"> <col style="width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:3291;width:68pt" width="90"> <col style="mso-width-source:userset;mso-width-alt:2633;width:54pt" width="72"> </colgroup><tbody><tr style="height:60.0pt" height="80"> <td class="xl66" style="height:60.0pt;width:52pt" height="80" width="69">Ticket No.( Task)</td> <td class="xl79" style="border-left:none;width:68pt" width="90">Allocation Date</td> <td class="xl66" style="border-left:none;width:86pt" width="115">Resource Name</td> <td class="xl79" style="border-left:none;width:68pt" width="90">Plan Start Date</td> <td class="xl79" style="border-left:none;width:68pt" width="90">Plan End Date</td> <td class="xl66" style="border-left:none;width:51pt" width="68">Planned Effort(in-hours)</td> <td class="xl79" style="border-left:none;width:68pt" width="90">Actual Start Date</td> <td class="xl79" style="border-left:none;width:68pt" width="90">Actual End Date</td> <td class="xl66" style="border-left:none;width:48pt" width="64">Actual Effort(in-hours)</td> <td class="xl66" style="border-left:none;width:68pt" width="90">No. Of Days
(Days taken to Resolve one ticket)</td> <td class="xl66" style="border-left:none;width:54pt" width="72">Status</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl68" style="height:15.0pt;border-top:none" height="20">12478</td> <td class="xl69" style="border-top:none;border-left:none">1-Apr-12</td> <td class="xl70" style="border-top:none;border-left:none">Daya Shankar</td> <td class="xl69" style="border-top:none;border-left:none">1-Apr-12</td> <td class="xl69" style="border-top:none;border-left:none">4-Apr-12</td> <td class="xl67" style="border-top:none;border-left:none" align="right">2</td> <td class="xl69" style="border-top:none;border-left:none">1-Apr-12</td> <td class="xl69" style="border-top:none;border-left:none">4-Apr-12</td> <td class="xl67" style="border-top:none;border-left:none" align="right">5</td> <td class="xl67" style="border-top:none;border-left:none" align="right">4</td> <td class="xl70" style="border-top:none;border-left:none">Pending</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl68" style="height:15.0pt;border-top:none" height="20">12502</td> <td class="xl69" style="border-top:none;border-left:none">1-Apr-12</td> <td class="xl70" style="border-top:none;border-left:none">Sandeep Kumar</td> <td class="xl69" style="border-top:none;border-left:none">1-Apr-12</td> <td class="xl69" style="border-top:none;border-left:none">5-Apr-12</td> <td class="xl67" style="border-top:none;border-left:none" align="right">2</td> <td class="xl69" style="border-top:none;border-left:none">1-Apr-12</td> <td class="xl69" style="border-top:none;border-left:none">5-Apr-12</td> <td class="xl67" style="border-top:none;border-left:none" align="right">5</td> <td class="xl67" style="border-top:none;border-left:none" align="right">5</td> <td class="xl70" style="border-top:none;border-left:none">Pending</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl68" style="height:15.0pt;border-top:none" height="20">12539</td> <td class="xl69" style="border-top:none;border-left:none">1-Apr-12</td> <td class="xl70" style="border-top:none;border-left:none">Harish Narayan</td> <td class="xl69" style="border-top:none;border-left:none">2-Apr-12</td> <td class="xl69" style="border-top:none;border-left:none">4-Apr-12</td> <td class="xl67" style="border-top:none;border-left:none" align="right">2</td> <td class="xl69" style="border-top:none;border-left:none">2-Apr-12</td> <td class="xl69" style="border-top:none;border-left:none">4-Apr-12</td> <td class="xl67" style="border-top:none;border-left:none" align="right">5</td> <td class="xl67" style="border-top:none;border-left:none" align="right">3</td> <td class="xl70" style="border-top:none;border-left:none">Closed</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl68" style="height:15.0pt;border-top:none" height="20">12595</td> <td class="xl69" style="border-top:none;border-left:none">2-Apr-12</td> <td class="xl70" style="border-top:none;border-left:none">Sandeep Kumar</td> <td class="xl69" style="border-top:none;border-left:none">2-Apr-12</td> <td class="xl69" style="border-top:none;border-left:none">5-Apr-12</td> <td class="xl67" style="border-top:none;border-left:none" align="right">2</td> <td class="xl69" style="border-top:none;border-left:none">2-Apr-12</td> <td class="xl69" style="border-top:none;border-left:none">5-Apr-12</td> <td class="xl67" style="border-top:none;border-left:none" align="right">5</td> <td class="xl67" style="border-top:none;border-left:none" align="right">4</td> <td class="xl70" style="border-top:none;border-left:none">Closed</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl68" style="height:15.0pt;border-top:none" height="20">12616</td> <td class="xl69" style="border-top:none;border-left:none">2-Apr-12</td> <td class="xl70" style="border-top:none;border-left:none">Subhash Verma</td> <td class="xl69" style="border-top:none;border-left:none">2-Apr-12</td> <td class="xl69" style="border-top:none;border-left:none">4-Apr-12</td> <td class="xl67" style="border-top:none;border-left:none" align="right">2</td> <td class="xl69" style="border-top:none;border-left:none">2-Apr-12</td> <td class="xl69" style="border-top:none;border-left:none">5-Apr-12</td> <td class="xl67" style="border-top:none;border-left:none" align="right">5</td> <td class="xl67" style="border-top:none;border-left:none" align="right">4</td> <td class="xl71" style="border-top:none;border-left:none">Closed</td> </tr> </tbody></table>