Free TimeTrex resource
Calculate elapsed calendar days from requisition approval to offer acceptance. Keep candidate time to hire, optional hold adjustments and the start-date delay separate.
Use dates from the same filled position. Example dates are illustrative. Do not enter names or personal candidate information.
Calendar days include weekends and holidays. The starting date is excluded: September 1 to October 1 is 30 days; the same date is 0 days.
Gross time to fill always includes holds. The adjusted figure is a separate custom metric. Candidate time to hire and start delay are separate clocks; do not add them to gross time to fill.
Gross time to fill = offer accepted date − requisition approved date. Adjusted elapsed time = gross time to fill − hold days. Target gap = gross time to fill − chosen target.
Approval on September 1 and acceptance on October 1 gives 30 calendar days. Five hold days produces 25 adjusted days. Against a 28-day gross target, the gap is +2 days. A negative gap means fewer days than the chosen target.
If the candidate entered on September 10, candidate time to hire is 21 days. If work begins October 15, the acceptance-to-start delay is 14 days. Neither figure changes the 30-day gross time to fill.
Time to fill uses the requisition clock. Time to hire uses the successful candidate’s pipeline entry date. A candidate already in a talent pool can enter before approval, so candidate time to hire can exceed time to fill. A later start date measures another delay.
Organizations and ATS reports can use different events, such as job posting rather than requisition approval. Reconcile those definitions before comparison. This tool uses approval, acceptance and calendar-date subtraction consistently.
Hold days are a user-entered adjustment, not detected automatically. Count the union of elapsed hold intervals within the approval-to-acceptance period. For example, September 10 to September 15 is five elapsed days. Do not deduct a hold twice or deduct more than the gross duration.
This worksheet handles completed offer-acceptance timelines. Track open-role age separately; do not substitute today’s date and label the result completed time to fill. A rescinded offer or reopened requisition needs a documented policy before reporting.
Dates range from 2000 through 2100. Optional dates can be cleared. Target and hold inputs accept nonnegative whole days up to 40,000; holds cannot exceed gross time. Leap days are included. Daylight-saving changes do not add or remove calendar days. No business-day or legal deadline calculation is performed.
One completed timeline is not an average or forecast. When combining records, use a consistent filled-position unit and reporting cohort; multi-opening and evergreen requisitions need a documented approach. Inspect delays alongside job requirements, approvals, availability and record quality. No speed metric alone establishes hiring quality or a need for staffing changes.
Keep authoritative job and applicant records in your authorized recruitment workflow. This browser worksheet does not save inputs or connect to an ATS.
Copy this CSV if your browser blocks the download.
Primary sources checked October 22, 2026. The recruiting definitions below inform this worksheet; the date convention, optional hold adjustment and target comparison are explicitly defined here. No benchmark or compliance standard is imported.
Disclaimer: This voluntary worksheet calculates elapsed calendar days from user-entered recruitment dates. It is not a forecast, legal deadline calculator, hiring recommendation or assessment of any person. Results depend on the chosen start event, record accuracy and a consistent hold-day policy. Targets and example dates are illustrative, not benchmarks. A faster result does not establish hiring quality, fairness, compliance or adequate staffing. 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.