Calculator Inputs
Formula Used
Adjusted Eligible Learners = Assigned Learners − Exempt Learners − Withdrawn Learners
Completion Rate = (Completed Learners ÷ Selected Denominator) × 100
Start Rate = (Started Learners ÷ Adjusted Eligible Learners) × 100
Pass Rate = (Passed Learners ÷ Completed Learners) × 100
Drop-off Rate = ((Started Learners − Completed Learners) ÷ Started Learners) × 100
Overdue Rate = (Overdue Learners ÷ Adjusted Eligible Learners) × 100
Learners Needed for Target = Ceiling[(Target % × Denominator) − Completed Learners]
Completed Training Hours = Completed Learners × Course Hours per Learner
How to Use This Calculator
- Enter the course name, reporting period, and department.
- Fill in assigned, exempt, withdrawn, started, completed, passed, and overdue learner counts.
- Select whether the completion rate should use adjusted eligible learners or started learners.
- Add target rate, course hours, cost per learner, and hourly wage for richer analysis.
- Click Calculate Completion Rate to view results, metrics, graph, and export options.
Example Data Table
| Team | Assigned | Exempt | Withdrawn | Adjusted Eligible | Started | Completed | Passed | Overdue | Completion Rate |
|---|---|---|---|---|---|---|---|---|---|
| Sales | 85 | 2 | 3 | 80 | 72 | 64 | 60 | 8 | 80.00% |
| Tech | 140 | 4 | 6 | 130 | 121 | 110 | 105 | 9 | 84.62% |
| HR | 48 | 1 | 1 | 46 | 44 | 42 | 41 | 2 | 91.30% |
| Support | 96 | 3 | 5 | 88 | 77 | 68 | 64 | 11 | 77.27% |
FAQs
What does the course completion rate measure?
It shows what share of the selected learner group finished the course during the reporting period. Most HR teams use adjusted eligible learners as the denominator for compliance and rollout reporting.
Should I use eligible or started learners as the denominator?
Use adjusted eligible learners for assignment-based compliance reporting. Use started learners when you want to measure how many active learners actually finished after beginning the course.
Why subtract exempt and withdrawn learners?
Exempt or withdrawn learners usually should not count against the training program. Removing them gives a cleaner denominator and prevents underreporting performance.
What does pass rate tell me?
Pass rate shows how many completed learners also passed the assessment. A strong completion rate with a weak pass rate may signal content difficulty or inadequate preparation.
Why track overdue learners separately?
Overdue learners reveal time-based risk. Completion can look acceptable overall while overdue counts still threaten compliance, audits, or manager follow-up.
What is a good target completion rate?
For required compliance learning, many teams target very high completion, often 90 percent or higher. Voluntary development programs may use lower targets depending on enrollment goals and duration.
Can I use this calculator for monthly reporting?
Yes. Enter the reporting period, course details, and current counts for any month, quarter, or campaign. The calculator works for recurring snapshots and trend reviews.
Does course cost change the completion rate?
No. Cost does not change the completion percentage. It adds budget context so HR teams can compare completion performance with training spend and learner time value.