Everhour tracks time and approved leave, while Google Sheets can calculate utilization from billable hours and firm-defined capacity.
Measure billable utilization against total capacity and see exactly how many hours you're leaving on the table each period.
Working hours this period
Industry average for agencies: 75–85%
The calculator gives you the number — Everhour takes it from there.
One click and you're timing. Start a timer, add an entry, edit the details. This is exactly how it feels in Everhour.
Set a budget, assign rates, and get alerted before you're over.
Measurement
Track your budget through time or costs
Every report you need — configured your way, always up to date.
Tracked hours flow straight into a polished invoice — no copy-paste, no manual math.
A utilization report in Google Sheets answers a practical staffing question: how much available capacity turned into billable work during a chosen period. The core calculation is billable hours divided by available hours. Google Sheets handles the formulas, filters, pivot tables, and imports, while your firm defines whether available hours mean gross capacity, scheduled working time, or scheduled working time net of leave.
The report needs clean source columns before it can produce trustworthy rollups. Label fields such as date, person, role, team, project, hours, billable flag, PTO, and holiday status. Pivot tables and QUERY rollups depend on those headers. Dropdowns or data validation also keep billable, non-billable, PTO, holiday, project, and role labels from splitting totals across inconsistent text values.
U.S. utilization reporting does not start from a statutory national target. The FLSA does not define full-time or part-time employment, so full-time capacity is an employer policy for utilization purposes. Many U.S. firms use 40 hours as a gross weekly capacity baseline because covered nonexempt employees receive federal overtime pay for hours worked over 40 in a fixed 168-hour workweek.
A 40-hour weekly baseline equals 2,080 gross annual hours before company PTO, holidays, unpaid leave, or other nonworking time. The FLSA does not require payment for time not worked, including vacations, sick leave, or federal or other holidays. Private-sector paid holidays remain a policy, contract, or jurisdiction-specific matter, even though OPM lists 11 federal holidays for federal employees in 2026.
In Google Sheets, billable hours usually come from a flat time table using SUMIFS over the hours column with criteria for billable status, person, role, team, project, and date range. Available hours can use a working-time shape such as NETWORKDAYS(start date, end date, holidays) multiplied by daily capacity hours, then reduced by PTO or other leave hours.
For one consultant, assume 5 working days at 8 hours per day, 4 hours of PTO, and 27 billable hours. Available hours equal 36. Utilization is 27 divided by 36, or 75%. At a $165 standard billing rate, those billable hours carry $4,455 of billable value, and the effective value across available capacity is $123.75 per available hour.
Google Sheets NETWORKDAYS treats Saturday and Sunday as weekends by default. A firm with a different weekend pattern needs NETWORKDAYS.INTL, or the denominator will include or exclude the wrong days. A utilization formula also needs a zero-denominator guard because DIVIDE cannot use zero available hours for a person on full leave, an inactive role, or a future period with no scheduled capacity.
Imported data needs the same caution. IMPORTRANGE can pull time entries, PTO, holidays, or capacity tables from another spreadsheet after access is granted, but it checks for updates every hour while the destination document is open and can lag across chained imports. Automated feeds can append rows through spreadsheets.values.append, but the report still needs controlled labels and a clear table boundary.
A one-off Google Sheets report is enough when you need a quick utilization check for one person, one team, or one closed period. Keep the source table small, protect the formula columns, and review the denominator before sharing the result. The spreadsheet ends where approval history, leave requests, payroll review, or billing handoff begins.
A managed workflow becomes necessary when utilization affects staffing, client billing, payroll review, or performance reporting every week. Everhour can track approved time off alongside work time, then let time-off hours flow into timesheets and reports. That gives the utilization report a steadier source for vacations, sick leave, custom leave types, partial-day absences, and approved capacity reductions.
This content is for general information only, may not be fully up to date, and is provided without any warranty or liability.
High Performer
G2
Summer 2026
Best Ease Of Use
Capterra
Summer 2026
Rated in the top time trackers across G2, Capterra, and TrustRadius — with consistent praise for ease of use, integrations, and support.
Divide summed billable hours by the available-hours denominator for the same person, team, and period. Google Sheets can calculate billable hours with SUMIFS and roll up results with a pivot table or QUERY. The formula is only as accurate as the denominator policy behind it, especially when PTO, holidays, unpaid leave, or part-time capacity changes available hours.
Use one source-data column per field: date, person, role, team, project, hours, billable flag, PTO, holiday status, and capacity. Add client or service-line columns if managers review utilization that way. Clear headers matter because pivot tables require labeled source columns, and formulas need stable column references to keep person-level and team-level totals aligned.
A utilization formula needs a guard for zero available hours. A person can have zero available hours during full leave, before a start date, after a termination date, or in a future period with no assigned capacity. Returning a blank or review label is cleaner than forcing a percentage, because utilization cannot be calculated when the divisor is zero.
IMPORTRANGE can pull a specified range from another Google Sheets file after access is granted. That works for time entries, PTO logs, holiday tables, or capacity rosters stored separately. The limitation is refresh timing: imported utilization dashboards are not real time because IMPORTRANGE checks for updates hourly while the destination document is open and can lag across chained imports.
Federal holidays reduce available hours only if your firm's denominator policy excludes them for the workers being measured. OPM lists 11 federal holidays in 2026 for federal employees. Private-sector paid holidays are a matter of employer policy, contract, or another applicable rule, and the FLSA does not require payment for time not worked.
Everhour Time Off tracks vacations, sick leave, holidays, and custom leave types with partial-day durations, accrual, carryover, per-employee balances, and approval workflow. Approved time-off hours flow into timesheets and reports, giving utilization calculations a cleaner basis for capacity reductions than manually edited PTO columns in a spreadsheet.
Everhour Reporting turns logged time, budgets, costs, and project data into configurable reports with columns, grouping, filters, date ranges, and exports to CSV, Excel/XLSX, or PDF. Teams can review utilization-related hours in operational reports before sending spreadsheet files, payroll summaries, or billing support to the next workflow.
Track leave, approvals, and capacity changes before the spreadsheet stage. Everhour Time Off connects approved absences to timesheets and reports, giving recurring utilization reporting a cleaner denominator.
14-day free trial · No credit card · Cancel anytime
