Meetings consume more than the time shown on a calendar. Their real cost includes every attendee’s working hours, preparation, follow-up, and the focus time displaced by the event. This guide shows how to build and use a meeting cost spreadsheet, audit recurring meetings, compare common meeting types, and use a team meeting schedule template to reduce waste without removing necessary collaboration.
Overview
A meeting cost calculator is a planning tool, not a judgment about whether meetings are valuable. A short decision meeting may cost more than a routine check-in, but it may also prevent rework or unblock a project. The purpose of calculating cost is to make that trade-off visible.
For a basic estimate, calculate the combined hourly cost of attendees and multiply it by the meeting length. Then add preparation and follow-up time when those activities are material.
Basic meeting cost formula:
Meeting cost = meeting hours × total attendee hourly rates
Expanded meeting cost formula:
Total cost = meeting cost + preparation cost + follow-up cost
For recurring meetings, multiply the cost of one occurrence by the number of occurrences in the selected period. A weekly meeting may be reviewed monthly, quarterly, or annually, depending on the decision you are making.
You can set up the calculator in a Google Sheets calendar template, an Excel calendar template, or a separate spreadsheet connected to your team calendar. A useful meeting cost spreadsheet should show both the cost of each meeting and the assumptions behind the result.
| Meeting type | Typical purpose | Starting point for frequency | Starting point for duration | Cost-control question |
|---|---|---|---|---|
| Standup | Share brief updates, blockers, or handoffs | Daily or a few times per week, only when coordination requires it | 15–20 minutes | Could an asynchronous update handle routine information? |
| Status review | Review progress, risks, dependencies, or decisions needed | Weekly or biweekly | 30–45 minutes | Are attendees receiving information they need to act on? |
| Decision meeting | Resolve an issue that needs discussion or authority | As needed | 30–60 minutes | Are the decision owner and required inputs clear? |
| Brainstorming session | Generate, compare, or develop ideas | At project milestones or when a defined problem exists | 45–90 minutes | Is there a stated output and a method for selecting ideas? |
These are planning starting points rather than universal rules. The right schedule depends on the work, time zones, decision speed, and amount of coordination a team needs.
How to estimate meeting cost
Create a spreadsheet with one row for each meeting. Useful columns include meeting name, meeting type, attendees, duration, frequency, hourly rate for each attendee or attendee group, preparation time, follow-up time, and estimated period cost.
- List the attendees. Use the people normally invited, not only those who attend consistently. If attendance varies, create separate scenarios for a small and full group.
- Convert duration to hours. A 30-minute meeting is 0.5 hours; a 45-minute meeting is 0.75 hours. Keeping all time in hours makes the formulas easier to audit.
- Enter an hourly cost assumption. Use an internal planning rate approved by the business. This may be based on salary, loaded labor cost, billable rate, or another consistent method. Do not mix methods within one comparison unless you label the difference.
- Calculate one occurrence. Add the hourly rates of the attendees and multiply that total by the meeting duration.
- Add surrounding work. Estimate the time spent preparing an agenda, reviewing materials, documenting decisions, or completing assigned follow-up.
- Apply the frequency. Multiply the cost per occurrence by the number of meetings in the chosen period. For a recurring meeting, state whether the frequency is weekly, monthly, or another interval.
A simple spreadsheet formula might look like this:
=(DurationHours × SUM(AttendeeHourlyRates)) + PreparationCost + FollowUpCost
For a recurring meeting:
=CostPerOccurrence × OccurrencesInPeriod
Keep the calculator separate from the decision. First calculate the cost; then assess the meeting’s purpose, output, and alternatives. A meeting should not be removed simply because it is expensive, and a low-cost meeting should not continue automatically if it produces no useful result.
Inputs and assumptions
The quality of the estimate depends more on consistent inputs than on complex spreadsheet design. Record the assumptions in a separate tab or at the top of the worksheet so another person can review them later.
Hourly rates
Choose one method for the audit. For example, you might use an internal labor-cost estimate for everyone, or separate planning rates by role. If exact rates are sensitive or unavailable, use clearly labeled role bands. The result is an estimate for comparison, not a payroll calculation.
Attendance
Count people who are expected to attend. If optional attendees regularly join, include them in a second scenario. This can reveal whether the invitation list is larger than the meeting’s actual decision or information needs.
Preparation and follow-up
Do not add these costs automatically if they are negligible. Include them when the meeting requires recurring reports, pre-reading, minutes, action tracking, or substantial implementation work. Assign the time to the meeting only when the activity would not otherwise occur.
Value and alternatives
Add columns for meeting owner, intended output, decision required, and possible alternative. Alternatives may include an asynchronous update, shared document, office-hours block, email summary, or smaller working session. A team calendar template can help distinguish meetings that require real-time attendance from work that can be scheduled independently.
Worked examples
Consider a hypothetical weekly status meeting with six attendees. Assume the group uses a blended planning rate of 60 currency units per hour, the meeting lasts 45 minutes, and preparation plus follow-up adds 30 minutes of combined team time at the same blended rate.
The meeting time cost is:
0.75 hours × (6 × 60) = 270
The surrounding work costs:
0.5 hours × 60 = 30
The estimated cost per occurrence is therefore 300 currency units, using the stated assumptions. If the meeting occurs four times in a month, the estimated monthly cost is 1,200 currency units. These figures are illustrative, not a benchmark; replace them with your own inputs.
Now compare two options. Option A keeps the weekly meeting at 45 minutes with six attendees. Option B changes it to a 30-minute meeting with four required attendees and sends a written update to the wider group. Under the same illustrative rate, Option B’s meeting time cost is:
0.5 hours × (4 × 60) = 120
The saving is not automatically a reason to choose Option B. Check whether the smaller group can make the required decisions, whether excluded people still receive useful information, and whether the written update creates new work. Record the decision and review it after a defined trial period.
For a practical audit, sort the spreadsheet by recurring monthly cost, then review the highest-cost meetings first. Look for clear changes: fewer attendees, shorter duration, lower frequency, a defined end date, or a change from discussion to asynchronous reporting.
When to recalculate
Run a meeting audit at least quarterly if your team’s schedule changes regularly. Recalculate sooner when hourly-rate assumptions change, team membership shifts, a meeting becomes longer or more frequent, or a remote or hybrid workflow changes attendance patterns.
Use the same worksheet for each review so results remain comparable. Save the audit date, assumptions, meeting list, and resulting actions. A useful history might include:
- Estimated cost before the change
- Change made to duration, frequency, attendance, or format
- Estimated cost after the change
- Owner responsible for checking the outcome
- Date for the next review
After changing a meeting, check more than the spreadsheet total. Confirm that decisions are still made on time, blockers are visible, handoffs are clear, and follow-up actions are completed. If meeting reduction creates delays elsewhere, include that effect in the next review.
For a broader scheduling workflow, pair the calculator with a small business scheduling system and a time blocking template that protects focused work. You can also use the meeting cost calculator guide as a companion reference. The practical next step is simple: export or list your recurring meetings, enter transparent assumptions, rank them by estimated cost, and choose one meeting to test with a smaller group, shorter duration, or clearer output before your next quarterly audit.
