Free TimeTrex resource
Compare the share of each starting employee group promoted, using clear counts and consistent reporting periods.
Use the same organizational scope and equal-length periods. Count only people present at the start of each period.
For each period, S = starting employees and P = unique employees from that group promoted. Promotion rate R = P ÷ S × 100 when S is positive. Starting group not promoted = S − P. Rate difference = current R − earlier R, in percentage points. Relative rate change = (current R ÷ earlier R − 1) × 100 when the earlier rate is positive. Change in promoted people = current P − earlier P; this is a count difference, not a percentage.
In the example, 24 of 200 starting employees were promoted: 24 ÷ 200 × 100 = 12.00%. The earlier period has 18 of 180: 10.00%. The difference is +2.00 percentage points, the relative rate increase is +20.00%, and six more starting employees were promoted. The current group not promoted is 176. These inputs illustrate the calculation and are not typical results, a target or a recommended promotion budget.
A move from 10% to 12% adds 2 percentage points. Compared with the earlier 10%, that is a 20% relative increase. Both describe the same rates in different ways. The tool computes comparisons from unrounded ratios and rounds displayed results to two decimal places. Show the employee counts beside the rates, particularly for small groups.
A positive starting group with zero promotions has a 0.00% rate. A zero starting group with zero promotions has an undefined rate, displayed as N/A rather than 0%. A positive promoted count with zero starting employees, or any promoted count above its group size, is invalid.
A rate difference requires defined rates in both periods. Relative change also requires a positive earlier rate. A move from 0% to 12% therefore has a +12 percentage-point difference but N/A relative change. A fall from a positive earlier rate to zero has a −100% relative change. A count difference is still defined when a group is empty.
This tool divides promoted people from a starting employee group by that group’s size. An internal fill rate divides internally filled vacancies by all filled vacancies; internal fills may include lateral moves. One employee may also fill more than one role during a period. These measures answer different questions and should not share a denominator.
The stated cohort method is an independent convention. Other reports may count promotion events, include later hires or use another headcount date. Check definitions before comparing results with a vendor metric. This worksheet imports no benchmark, applies no annualization and makes no inference about retention, engagement, quality or why a rate changed.
All four inputs accept plain whole numbers from 0 to 1,000,000. Blank, negative, fractional, comma-separated and exponent-form entries are rejected. A promoted count above its starting group is rejected. CSV and print are disabled for invalid inputs and include aggregate inputs, formulas, results and the counting convention for valid inputs.
Calculations run within this browser component without application storage or a connection to HR or payroll records. Enter aggregate counts only. Keep reporting dates, organizational scope, promotion criteria and supporting records in your own notes. Browser settings can affect downloads and printing. Human review remains necessary before relying on any result.
Copy this CSV if your browser blocks the download.
Definitions checked October 29, 2026. This independent worksheet states its own fixed-cohort counting convention and imports no benchmark values.
Disclaimer: This voluntary worksheet measures unique people promoted from a fixed starting employee group during each chosen period. It excludes later hires, counts repeat promotions once, and uses starting headcount rather than average headcount or filled vacancies. Results depend on complete records and consistent scope, promotion criteria and period length; they do not reproduce a vendor benchmark, assess employee eligibility or performance, prove a cause, or recommend individual promotion, pay or staffing decisions. 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.
Trusted By
Join our ever-growing community of satisfied customers today and experience the unparalleled benefits of TimeTrex.
Strength In Numbers
Time To Clock-In
Experience the Ultimate Workforce Solution and Revolutionize Your Business Today
Saving businesses time and money through better workforce management since 2003.
Copyright © 2026 TimeTrex. All Rights Reserved.