KPI category
HR KPI Formulas
HR KPI formulas for hiring, retention, headcount, absenteeism, workforce productivity, and people analytics.
Affiliate resources
Ideas for You
Useful learning resources related to this page. As an Amazon Associate, this site may earn from qualifying purchases at no extra cost to you.
HR KPI books
Books that help you understand HR KPI and related business metrics more deeply.
Explore resources →
HR KPI audiobooks
Audiobook searches for learning HR KPI while commuting, walking, or working.
Explore resources →
People analytics resources
Excel-focused resources for building KPI trackers and dashboard workflows.
Explore resources →
Recruiting analytics resources
Practical resources for turning HR KPI into reports, dashboards, and business decisions.
Explore resources →
Popular formulas
Common HR KPIs
Employee Turnover RateEmployees Who Left / Average Number of EmployeesVoluntary Turnover RateVoluntary Departures / Average Number of EmployeesAbsenteeism RateAbsence Days / Available Work DaysRevenue per EmployeeRevenue / Number of EmployeesCost per HireTotal Recruiting Cost / Number of HiresTime to HireOffer Accepted Date - Application DateTime to FillPosition Filled Date - Job Opened DateOffer Acceptance RateAccepted Offers / Total OffersEmployee Retention RateEmployees Remaining / Employees at Start of PeriodTraining Cost per EmployeeTotal Training Cost / Employees TrainedEmployee ProductivityOutput / Employee HoursHeadcount Growth Rate(Current Headcount - Previous Headcount) / Previous Headcount
All HR KPI formulas
| KPI | Formula | Excel | Tool |
|---|---|---|---|
| Employee Turnover Rate | Employees Who Left / Average Number of Employees | =IFERROR(B2/C2,0) | Calculator |
| Voluntary Turnover Rate | Voluntary Departures / Average Number of Employees | =IFERROR(B2/C2,0) | Calculator |
| Absenteeism Rate | Absence Days / Available Work Days | =IFERROR(B2/C2,0) | Calculator |
| Revenue per Employee | Revenue / Number of Employees | =IFERROR(B2/C2,0) | Calculator |
| Cost per Hire | Total Recruiting Cost / Number of Hires | =IFERROR(B2/C2,0) | Calculator |
| Time to Hire | Offer Accepted Date - Application Date | =B2-C2 | Calculator |
| Time to Fill | Position Filled Date - Job Opened Date | =B2-C2 | Calculator |
| Offer Acceptance Rate | Accepted Offers / Total Offers | =IFERROR(B2/C2,0) | Calculator |
| Employee Retention Rate | Employees Remaining / Employees at Start of Period | =IFERROR(B2/C2,0) | Calculator |
| Training Cost per Employee | Total Training Cost / Employees Trained | =IFERROR(B2/C2,0) | Calculator |
| Employee Productivity | Output / Employee Hours | =IFERROR(B2/C2,0) | Calculator |
| Headcount Growth Rate | (Current Headcount - Previous Headcount) / Previous Headcount | =IFERROR((B2-C2)/C2,0) | Calculator |
| eNPS | % Promoters - % Detractors | =B2-C2 | Calculator |
| Promotion Rate | Employees Promoted / Total Employees | =IFERROR(B2/C2,0) | Calculator |
How to use these KPIs
Start with a small set of metrics that connect to decisions. Define each KPI once, document the formula, and reuse the same calculation in Excel, dashboards, and business reports.
Build dashboards faster
Each KPI page includes a plain formula, Excel formula, Power BI DAX measure, calculator, related KPIs, and common mistakes to avoid.