Your agency logged 64 hours of client work last week. Was that a busy week? The answer depends on how much time your team had available and whether those 64 hours include work you classify as billable. A full-time employee, a part-time designer, and someone who took a day of leave contribute different amounts of capacity.
Here’s how to calculate billable utilization for a small service team. This guide uses scheduled hours less approved leave and holidays as its capacity measure. You’ll see how to apply that rule consistently, calculate the team rate, and spot situations where a higher percentage hides a problem.
What is billable utilization?
Billable utilization is the share of available work hours spent on billable client work during a defined period. It helps you see how much of your team’s capacity went to paid client delivery. Use the same dates and group of people for both sides of the calculation.
Billable utilization (%) = Billable client hours ÷ Available work hours × 100
For example, a consultant who logs 26 billable hours and has 32 available hours has 81.25% billable utilization for the week. The remaining six hours may include internal meetings, training, or time without assigned work.
1. Decide which hours count as billable
Start with hours worked on client tasks that qualify as billable under your team’s reporting rules. Use time entries for the period you are measuring, even if the invoice goes out later.
| Work logged | How to classify it |
|---|---|
| Approved hourly client delivery | Billable client work |
| Delivery covered by a fixed-fee project | Billable client work if your reporting policy includes it |
| Internal training, hiring, or team meetings | Non-billable work |
| Proposal preparation and unpaid discovery | Non-billable unless the client is paying for that work |
| Out-of-scope rework or hours written off | Track separately or classify according to your documented policy |
How to handle fixed-fee projects
For a fixed-fee project, record the time spent on delivery even though the client pays for the result rather than each hour. If your report counts that time in billable utilization, apply the rule to every fixed-fee project. Keep written-off hours or overruns visible so you can see when the project took more time than you priced.
Suppose a fixed-fee website project takes 42 hours when you budgeted 30. Those hours may contribute to utilization while the extra 12 hours reduce the effective revenue per hour. Review project profitability separately so utilization doesn’t mask the overrun.
2. Calculate available hours consistently
For a capacity-based view, start with each person’s scheduled hours and deduct approved leave and holidays that fall within their schedule. For a part-time employee who works 24 hours a week, start with 24. If a holiday falls on their usual day off, there are no scheduled hours to deduct for that day.
Keep ordinary internal work and unassigned time in the denominator. Excluding a slow afternoon or an internal meeting would make the percentage higher without creating any additional billable work.
Some teams report against gross scheduled hours to compare results with a budget. That approach answers a different question. For example, 26 billable hours divided by 40 scheduled hours is 65%. With eight hours of leave deducted, the same work divided by 32 available hours is 81.25%. Label your measure and keep it consistent between periods.
3. Calculate individual and team utilization
The following weekly figures are illustrative.
| Team member | Scheduled hours | Leave or holiday hours | Available hours | Billable hours | Utilization |
|---|---|---|---|---|---|
| Consultant | 40 | 8 | 32 | 26 | 81.25% |
| Designer | 24 | 0 | 24 | 18 | 75.00% |
| Project lead | 40 | 0 | 40 | 20 | 50.00% |
| Team total | 104 | 8 | 96 | 64 | 66.67% |
Team utilization = 64 ÷ 96 × 100 = 66.67%, rounded to two decimals.
Divide total billable hours by total available hours. Averaging the three individual rates would give 68.75%, because that method treats the 24-hour schedule and the 40-hour schedule as equally large. Use the same totals-based approach when combining weeks into a monthly result.
4. Build the calculation in a spreadsheet
Enter one row per person per reporting period. For this example, rows 2 through 4 contain the team. Columns B and C contain scheduled hours and leave hours, column D contains available hours, column E contains billable hours, and column F contains utilization.
| Cell | Formula | Purpose |
|---|---|---|
| D2 | =B2-C2 | Calculates available hours. Copy down for each person. |
| F2 | =IF(D2>0,E2/D2,"") | Calculates individual utilization when capacity is positive. Copy down. |
| F5 | =IF(SUM(D2:D4)>0,SUM(E2:E4)/SUM(D2:D4),"") | Calculates team utilization from the hour totals. |
Format column F as a percentage. A blank rate can represent a person with no available hours for the period. Before sharing the team result, check for negative available hours and any row that shows billable time against zero capacity. The latter can signal overtime, leave recorded against the wrong period, or a time-entry error. Resolve it using your reporting policy before rolling up the totals.
5. Use the result to diagnose capacity
Compare results by role and across similar periods. A project lead may spend more time on proposals, staffing, or internal operations than a delivery specialist. Review those responsibilities before drawing conclusions from their different percentages.
| What you see | What to check next |
|---|---|
| Low utilization and few client assignments | Look at the project pipeline, scheduling gaps, and skill availability. |
| Low utilization with a full project schedule | Check for missing timesheets, misclassified work, and delays caused by client dependencies. |
| High utilization and recurring overtime | Review workload and compare billable hours with actual hours worked. |
| High utilization and weak project margins | Check fixed-fee overruns, write-offs, and effective revenue per hour. |
Set role-specific expectations using your workload and budget. Reserve realistic time for training, administration, and business development. Check the assumptions against several comparable reporting periods before treating a rate as a target.
Frequently asked questions
What is a good billable utilization rate?
A useful target depends on the role, pricing model, and amount of internal work the business needs. Start with your budgeted client hours and expected capacity, then check whether the target leaves enough time for the rest of the role.
Should I include vacation and holidays?
For a capacity-based measure, subtract approved leave and holidays that overlap scheduled work. If your business uses gross scheduled hours for budgeting, retain that calculation as a separately labeled measure.
Are billable hours the same as invoiced hours?
Billable hours reflect work classified as billable when it is performed. Invoiced hours or amounts reflect what has been billed. Timing differences, fixed fees, and write-offs can make the figures diverge.
Can billable utilization exceed 100%?
Yes. For example, 42 billable hours divided by 40 scheduled available hours is 105%. Check whether overtime explains it or whether the hours or dates were entered incorrectly.
How is billable utilization different from total utilization?
Billable utilization counts billable client work. Total utilization can include other work your team chooses to count as productive, such as internal projects. Define both numerators and use the same denominator if you want to compare the rates.
Conclusion
Start with reliable time entries and one definition of available hours. Calculate the team rate from summed hours so part-time schedules and leave are reflected correctly. When the rate changes, compare it with the project schedule, overtime, and margins before deciding what to adjust.


