New Hire Retention Calculator

Free TimeTrex resource

New Hire Retention Calculator

Measure retention for a defined hire cohort at the same service milestone. Keep not-yet-eligible hires out of the rate and make your assumptions visible.

Define a comparable hire cohort

Use one intake cohort and one service milestone. Example counts are invented; reconcile your records before entering them.

Milestone retention results

New hire retentionRetained at milestone ÷ eligible hires × 100
Latest eligible start date
Eligible hires (denominator)
Not yet eligible (excluded)
Retained at their milestone
Left before their milestone
Cohort early-departure share
Retained outcomes required at target
Target outcome gap

How to prepare the counts

  1. Define the intake cohort, such as all hires starting in a particular quarter, and document the roles and locations included. Use one consistent observation date and milestone.
  2. A hire becomes eligible when start date plus the milestone days is on or before the observation date. The cutoff shown is the latest eligible start date. This worksheet does not inspect individual records or automatically validate the counts.
  3. Put all more recent hires in the not-yet-eligible count, even if they have already left. Excluding immature survivors but including immature departures would bias the rate.
  4. For eligible hires, determine whether they remained continuously employed through their own milestone. Count the eligible hires who left before it. Someone who left after reaching it still counts as retained at that milestone.
  5. Apply one written rule for transfers, leave and rehires. Here, a rehire is a new employment spell; it cannot undo a prior spell's departure. Do not treat ordinary leave as a departure when employment continues.
  6. Calculate, review the sample size and export the aggregate worksheet. Compare cohorts only when their definitions and milestones match.

Formulas and worked example

Eligible hires E = total cohort hires H − not-yet-eligible hires P. Retained hires R = E − eligible departures L. Retention = R / E × 100. Cohort early-departure share = L / E × 100. These two percentages sum to 100% only because they use the same eligible group and mutually exclusive outcomes.

With 100 hires, 20 not yet eligible and 12 eligible departures, E = 80 and R = 68. Retention is 85.00% and early-departure share is 15.00%. A 90% scenario needs round upward(80 × 0.90) = 72 retained outcomes, a gap of 4. This comparison cannot change historical departures and does not predict another cohort's results.

At an observation date of October 23, 2026 and a 90-day elapsed milestone, the latest eligible start date is July 25, 2026. Date calculations use calendar days, including weekends and holidays; time zones and daylight-saving hours do not change the date subtraction.

Milestone boundaries and incomplete cohorts

The start date is day 0. A person whose start date plus D days equals the observation date is eligible. For this worksheet, a last employed date equal to the milestone date counts as retained; a last employed date before it counts as left. If your system records the first non-employed date, reconcile it to the last employed date first.

If no hires are eligible, the rate, required outcomes and gap show N/A. The worksheet does not report a misleading zero-percent retention rate. It also shows how many hires are excluded. It does not estimate a survival curve or predict immature hires' outcomes.

A milestone is an elapsed-day count, not a calendar-month anniversary: 365 days and one year may differ around leap years. Verify date conventions against your records.

Target, rounding and input limits

Required retained outcomes = round upward(E × target / 100). Target outcome gap = max(0, required − actual retained). The chosen target accepts zero through 100 with up to two decimal places. Integer arithmetic is used for the target comparison, so exact whole outcomes do not accidentally round up because of floating-point noise.

Counts must be whole numbers from zero through 1,000,000. Not-yet-eligible hires cannot exceed total hires; eligible departures cannot exceed eligible hires. Milestones must be 1 through 3,650 days. Observation dates must be 2000 through 2100. Rates display two decimals; CSV retains calculation precision.

Interpretation and scope

A cohort result describes recorded outcomes; it does not establish why people left, whether onboarding caused an outcome, or whether an individual is suitable for employment. Small cohorts can move sharply when one person leaves. Consider role, location, contract length and record quality before comparing results.

This independently defined cohort worksheet is separate from whole-workforce turnover based on average headcount or a measure of new-hire departures as a share of all departures. Do not substitute one denominator for another or subtract an unrelated turnover percentage from 100.

The calculator runs in your browser, stores no inputs and does not connect to employee records. It provides aggregate planning arithmetic, with no employment, legal or compliance determination.

Sources and scope

Primary sources checked October 23, 2026. They provide context for retention and an explicit early-service horizon. The eligibility rules and formulas above define this independent worksheet; no benchmark or legal threshold is imported.

Disclaimer: This voluntary workforce planning worksheet uses user-reconciled aggregate hire-cohort counts and calendar-day milestones. It cannot verify eligibility, continuous service, separation dates, rehires, transfers or leave treatment. Outcomes refer to each eligible hire at their own milestone, not necessarily current employment. Its date cutoff is a calendar aid, not a legal service or probation rule. The chosen target is a hypothetical comparison, not an industry benchmark, forecast, assessment of an individual or recommendation for an employment decision. Small samples and inconsistent records can distort results. Verify all inputs, results and assumptions against appropriate records and obtain qualified advice before relying on them. To the fullest extent permitted by applicable law, this resource is provided “as is” without warranties of accuracy, completeness or fitness for a particular purpose, and TimeTrex and its affiliates disclaim liability for losses, damages, costs or claims arising from its use, inability to use, or reliance on it, including errors or omissions. Nothing in this disclaimer excludes or limits liability or rights that cannot lawfully be excluded or limited.

Found our Free New Hire Retention Calculator useful? Bookmark and share it.

Facebook
X
LinkedIn
Email
WhatsApp
Print
Navy onboarding calendar, blue progress ring and three abstract employee tokens on a white background

Trusted By

Trusted by 3.4M+ Employees: 23 Years of Service Across Startups to Fortune 500 Enterprises

Join our ever-growing community of satisfied customers today and experience the unparalleled benefits of TimeTrex.

Logo for H&R Block
Hilton Hotels and Resorts logo
HP computers logo
Oracle logo black and white
PWC brand logo
Texas A&M University logo
Mcdonald's brand logo
New York Stock Exchange Logo black and white
Walmart brand logo
London Drugs logo black and white

Strength In Numbers

Join The Companies Already Benefiting From TimeTrex

Users
0
Companies
0
Years
0

Time To Clock-In

Start your 30-day free trial!

Experience the Ultimate Workforce Solution and Revolutionize Your Business Today

TimeTrex Mobile App Hand