Staffing Calculator Excel: Calculate Staff Required (Free)

To calculate how many staff a team needs, divide its workload hours by the productive hours one full-time employee actually has, and round up:

Required staff = workload hours ÷ productive hours per employee

The part most people get wrong is the second number. A full-time employee is paid for about 2,080 hours a year, but after leave, holidays, training, meetings and breaks, only about 1,450–1,500 of those hours go into productive work, roughly 120–125 a month.

This guide shows how to work out productive hours, calculate required staff and the staffing gap for each department, read the results, and use the free Excel calculator.

Step 1: Work out productive hours per employee

Start from paid hours and remove time that isn't available for the work you are measuring. This reduction is often called shrinkage. An example for an office team working 40 hours a week:

Use your own leave policy, holiday list and working hours. Under the OSH Code, normal hours are capped at 48 a week, and annual leave accrues at one day for every 20 days worked. See the OSH Code guide.

Contact centres and shift teams often have higher shrinkage, 25–35%, because of absenteeism, coaching and system downtime. Measure yours rather than guessing.

Step 2: Measure workload in hours

Convert each team's work into hours for the same period, usually a month:

• Volume-driven teams: volume × average handling time. Example: 9,600 calls a month × 15 minutes = 2,400 hours.
• Project teams: the sum of estimated effort for planned tasks.
• Back-office teams: transactions × standard time per transaction, from time studies or system logs.

Use the same period for workload and productive hours. Monthly workload must be divided by monthly productive hours.

Step 3: Calculate required staff, gap and status

The formulas the Excel calculator uses (row 2; copy down):

Enter available staff as FTE, not headcount, when you have part-timers. Someone working 20 hours a week counts as 0.5 FTE.

Worked example: four departments

Using 123 productive hours per employee per month:

How to read the results

• Gap above 0 (understaffed): the team needs more capacity than it has. Utilisation above 100%, as in customer support at 108%, means overtime, backlogs or burnout are likely. Options include hiring, temporary or contract staff, approved overtime, or process automation.
• Gap below 0 (overstaffed): there is spare capacity. Accounts at 81% has about one person's worth of free time. Consider moving work in, cross-training, or not replacing the next leaver, rather than cutting jobs.
• Gap of 0 but utilisation near 100%: recruitment is "optimal" on paper but has no buffer. One resignation or long leave makes it understaffed.
• Healthy range: most teams work sustainably at roughly 80–90% utilisation of productive hours.

Rounding up to whole people is right for hiring decisions. For cost planning, compare unrounded figures (19.5 FTE vs 18) to see the true gap.

Put a cost on the gap

Add two columns: average monthly cost per employee, and gap × cost. For example:

• Customer support: 2 people at ₹45,000 CTC a month is ₹90,000 a month of capacity you are short of. You may be paying for it already through overtime.
• Accounts: the one person of spare capacity is ₹45,000 a month you could redeploy.

For overtime costs, use the overtime calculation guide, where overtime is paid at twice the ordinary rate. For staff cost per head, use the salary breakup calculator.

Using the Excel calculator

1. Staffing Calculator sheet: enter department names, monthly workload hours, productive hours per employee and available FTE. Required staff, gap and status fill in automatically.
2. Colour coding: Understaffed shows in red, Overstaffed in yellow, and Optimal in green.
3. Dashboard sheet: a bar chart of the gap by department, plus counts of departments in each status.
4. Adding departments: press Ctrl+T to convert the range to an Excel Table, so formulas, formatting and the chart extend to new rows automatically.
5. Common fixes:
   • #DIV/0! means productive hours is blank or zero.
   • Figures that don't update usually mean calculation is set to Manual. Change it under Formulas → Calculation Options → Automatic.

From staffing gap to workforce plan

This calculator answers "how many people does each team need for its current workload?" For next year's headcount plan, you also need:

• projected demand from the business plan;
• attrition;
• build, buy or borrow choices;
• a budget check.

See workforce planning for HRBPs, which includes a free workforce plan model. To track how the team is doing over time, use the HR dashboard Excel template.

Frequently asked questions

How do you calculate the number of staff required?

Divide total workload hours for a period by the productive hours one full-time employee has in the same period, and round up. For example, 2,400 monthly workload hours ÷ 123 productive hours = 19.5, so 20 people.

How many productive hours does an employee have in a month?

For a 40-hour week, after typical leave, holidays and training, and at 85% utilisation, about 120–125 hours a month. Calculate your own figure from your leave policy and working hours.

What is shrinkage in staffing?

The share of paid time not available for productive work, because of leave, holidays, training, meetings, breaks and absenteeism. Office teams often see 15–20%, and contact centres often 25–35%.

How do I count part-time employees?

Convert them to FTE: their hours divided by full-time hours. A 20-hour-a-week employee is 0.5 FTE when the full-time week is 40 hours.

What utilisation level is healthy?

Roughly 80–90% of productive hours. Sustained utilisation above 100% means the team is short-staffed, and below about 70% suggests spare capacity.

Is the staffing calculator free?

Yes. The Excel file is free to download, with no sign-up or macros.

Updated October 2026. The productive-hours and department figures are illustrative; replace them with your organisation's own data.