Prospecting Time-Audit Calculator
A one-week time-logging grid plus a rollup calculator that turns "I never have enough time to prospect" into an exact number of hours a week that admin, internal meetings, and CRM entry are quietly taking off your selling time.
What's inside
- 5-day, 30-minute-increment logging grid (8am-6pm)
- 6-code activity taxonomy: SELL / PREP / ADMIN / INTERNAL / TRAVEL / OTHER
- Weekly rollup formula for hours and % per category
- Selling-Time % benchmark table: Elite / Healthy / At Risk / Critical
- Leak-identification step to isolate your single biggest non-selling category
- 4 targeted recovery tactics, one per leak type
- Hours-given-back projection formula with worked example
- 30-day re-audit trigger and target movement
You already suspect the week isn't going where you think it's going. This turns that suspicion into a number: exactly how many hours a week are going to direct selling versus admin, internal meetings, and CRM housekeeping — and which one leak, fixed, gives you the most time back.
Step 1 — Log one full week
Every 30 minutes, write the code for what you actually did (not what was scheduled). Log honestly — this only works if the data is real.
Activity codes
| Code | Meaning |
|---|---|
| SELL | Live conversations with prospects/customers: cold calls, discovery, demos, negotiation, follow-up calls |
| PREP | Research, list-building, call planning, pre-call prep tied to a specific prospect |
| ADMIN | CRM data entry, expense reports, scheduling, paperwork, email triage not tied to an active deal |
| INTERNAL | Team standups, pipeline reviews, forecast calls, 1:1s, internal Slack/email |
| TRAVEL | Commuting to/from meetings, in-transit time |
| OTHER | Breaks, personal time, anything not covered above |
Daily log grid (copy this table 5 times, or print 5 copies — one per weekday)
| Time | Code | Time | Code |
|---|---|---|---|
| 8:00–8:30 | 1:00–1:30 | ||
| 8:30–9:00 | 1:30–2:00 | ||
| 9:00–9:30 | 2:00–2:30 | ||
| 9:30–10:00 | 2:30–3:00 | ||
| 10:00–10:30 | 3:00–3:30 | ||
| 10:30–11:00 | 3:30–4:00 | ||
| 11:00–11:30 | 4:00–4:30 | ||
| 11:30–12:00 | 4:30–5:00 | ||
| 12:00–12:30 | 5:00–5:30 | ||
| 12:30–1:00 | 5:30–6:00 |
Extend the grid if your day runs later than 6pm.
Step 2 — Weekly rollup
Add up total half-hour blocks per code across all 5 days, then convert to hours (blocks ÷ 2).
| Code | Total blocks (Mon–Fri) | Hours | % of week |
|---|---|---|---|
| SELL | |||
| PREP | |||
| ADMIN | |||
| INTERNAL | |||
| TRAVEL | |||
| OTHER | |||
| TOTAL | 100% |
Formulas:
- Hours = Total blocks ÷ 2
- % of week = (Hours in category ÷ Total logged hours) × 100
- Selling Time % = SELL hours ÷ Total logged hours × 100
Step 3 — Benchmark your Selling Time %
| Selling Time % | Band | Read |
|---|---|---|
| 50%+ | Elite | Rare — protect this ruthlessly, it's your edge |
| 40–50% | Healthy | Sustainable; small optimizations only |
| 25–40% | At Risk | Non-selling work is materially capping your output |
| Under 25% | Critical | You are structurally unable to hit a number built on selling time you don't have |
A useful working target for most quota-carrying roles: 40% of the logged week in direct SELL time. Below that, the shortfall isn't effort — it's calendar math.
Step 4 — Find your single biggest leak
Look at your rollup table. Excluding SELL and PREP (which are the job), whichever of ADMIN / INTERNAL / TRAVEL has the highest hour count is your leak. Fix that one first — chasing three leaks at once fixes none of them.
If ADMIN is the leak:
- Batch CRM entry into two fixed 15-minute windows a day (e.g. 11:45am and 4:45pm) instead of updating after every call.
- Use voice-to-text for call notes immediately after hanging up, then paste into CRM during the batch window.
- Template your 3 most common admin tasks (expense line items, standard proposal boilerplate, meeting recap emails).
If INTERNAL is the leak:
- List every recurring internal meeting you attend and ask, for each one: "Does the outcome change if I read the notes instead of attending?" Decline the ones where the answer is yes.
- Ask your manager to convert one recurring status meeting into an async update (shared doc, Slack thread).
- Batch internal 1:1s and check-ins back-to-back on one day rather than scattering them across the week.
If TRAVEL is the leak:
- Cluster in-person meetings by geography/day instead of criss-crossing across the week.
- Convert one recurring in-person internal touchpoint to video.
- Use commute time productively for PREP work you'd otherwise do at a desk (call planning, not deal work requiring a screen).
Step 5 — Project the time given back
Hours given back = (Leak category hours) × (realistic reduction %, typically 30–50% for a first pass)
Example: INTERNAL = 8 hours/week, 40% reduction target → 3.2 hours/week given back to SELL, or roughly 13 hours a month — more than a full selling day.
Step 6 — Re-audit
Run this same log again in 30 days. Your target: Selling Time % should move at least 5 points toward the next band up. If it hasn't moved, the leak wasn't behavioral — it's structural, and it's a conversation for your manager, not another personal fix.
How to use it
Print or copy the daily grid five times and log every 30-minute block for one working week using the six codes, then run the rollup formulas to see your real Selling Time % and biggest leak.