Lead to Close Time Calculator

Calculator Form

Enter your pipeline milestones, target timing, and workday settings to measure total lead-to-close time, response time, stage delays, and weighted pace.

Deal Name

Lead Source

Sales Rep

Deal Status

Deal Value ($)

Close Probability (%)

Lead Created *

First Contact

Qualified

Demo / Discovery

Proposal Sent

Negotiation

Closed *

Target Cycle Days

Weekend Rule

Exclude weekends from working time

Workday Start

Workday End

Example Data Table

Lead ID	Source	Lead Created	Closed	Value	Probability	Working Cycle Days
L-201	Inbound Demo	Mar 01 09:00	Mar 12 16:00	$8,500	60%	8.4
L-202	Referral	Mar 03 11:00	Mar 10 15:30	$14,200	85%	5.6
L-203	Webinar	Mar 05 10:30	Mar 21 14:15	$6,900	55%	11.0
L-204	Outbound	Mar 07 08:45	Mar 18 13:10	$18,000	70%	7.7
L-205	Partner	Mar 08 13:20	Mar 26 17:40	$25,000	90%	13.2

Formula Used

Core Cycle Logic Stage Timing Pipeline Pace

Total Calendar Hours = Closed Time − Lead Created Time.
Total Calendar Days = Total Calendar Hours ÷ 24.
Total Working Hours = Sum of valid hours inside each workday window.
Total Working Days = Total Working Hours ÷ Working Hours Per Day.
Stage Duration = Time between two consecutive completed milestones.
First Response Hours = First Contact − Lead Created.
Weighted Revenue Per Working Day = (Deal Value × Close Probability) ÷ Total Working Days.
Days Ahead / Behind Target = Target Cycle Days − Actual Working Days.

How to Use This Calculator

Enter the deal name, lead source, rep, and deal status.
Add the lead created time and the final closed time.
Fill optional milestone timestamps for contact, qualification, demo, proposal, and negotiation.
Set workday start, workday end, and weekend handling.
Enter deal value, close probability, and your target cycle days.
Press the calculate button to see summary metrics, stage delays, and the chart.
Use the CSV and PDF buttons to export the displayed results.

FAQs

1) What does this calculator measure?

It measures the time from lead creation to deal closure. It also shows working-time duration, milestone delays, first-response timing, longest stage, and revenue pace per working day.

2) Why can the working days differ from calendar days?

Calendar days include every hour between start and close. Working days only count hours inside your chosen work schedule, and they can ignore weekends when that option is selected.

3) Can I leave some milestone fields empty?

Yes. The calculator still works with only lead created and closed times. When optional stages are missing, it calculates timing across the next available milestone in sequence.

4) What is a good lead-to-close time?

A good cycle depends on deal size, product complexity, and market. Compare actual working days against your target cycle and past deals to set a useful internal benchmark.

5) What does weighted revenue per working day mean?

It estimates revenue pace by combining deal value with close probability, then dividing that weighted value by working days. It helps compare speed and commercial quality together.

6) Should I exclude weekends?

Exclude weekends when your team does not actively sell then. Include them if deals progress continuously, such as ecommerce, self-serve trials, or support-led weekend conversions.

7) Can I use this for lost or open deals?

Yes. For lost deals, the result highlights how long the opportunity stayed in the pipeline. For open deals, set the current time as a temporary closed value.

8) How can this improve pipeline management?

It reveals bottlenecks, late follow-up, proposal lag, and slow negotiation periods. Teams can use those findings to fix stage handoffs, tighten SLAs, and shorten cycle time.