Formula and assumptions
Productive FTE = workload ÷ scheduled hours per full-time employee. Scheduled FTE = productive FTE ÷ (1 − shrinkage) × (1 + buffer).
Results depend on your inputs. Read the calculation methodology.
FTE Calculator: Headcount and Staffing
Calculate full-time equivalents from team hours, or estimate staffing from workload and unavailable time. Choose the workflow that matches your question.
Headcount-to-FTE group planner
Compare scheduled weekly capacity with a scheduled-hours target. Enter anonymous groups, one per line: number of people, weekly hours per person. This is a capacity model, not a benefits or statutory reporting calculator.
Convert hours to FTE using the right baseline
For scheduled capacity, FTE equals team hours divided by the hours for one full-time schedule over the same period. A 0.8 FTE schedule is 32 hours under a 40-hour baseline, 30 hours under 37.5 and 28 hours under 35. The fraction alone does not specify a number of hours.
| Scheduled weekly hours | 40-hour baseline | 37.5-hour baseline |
|---|---|---|
| 20 | 0.50 FTE | 0.5333 FTE |
| 30 | 0.75 FTE | 0.80 FTE |
| 40 | 1.00 FTE | 1.0667 FTE |
Monthly FTE and spreadsheet checks
For a monthly comparison, divide monthly team hours by the full-time hours for that same month. For example, 504 hours divided by a 168-hour monthly baseline is 3.0 FTE. Dividing those hours by a weekly denominator would mix periods and misstate capacity.
To build an FTE calculator in Excel, enter headcount in B2:B4 and weekly hours per person in C2:C4. Put the weekly full-time baseline in F1, then use =SUMPRODUCT(B2:B4,C2:C4)/F1. Use numeric inputs and a positive baseline. The part-time FTE worksheet includes a complete mixed-team example.
Use the group planner for scheduled hours you already have. Use the workload calculation for hours you need. A volume-based estimate is not an interval-level call-center queue model or a nursing skill-mix roster.
Worked example
A 400-hour weekly workload divided by a 40-hour full-time baseline requires 10 productive FTE. With 20% shrinkage, schedule 12.5 FTE, equivalent to 13 people only if each person works full-time.
Understand the result
Workforce Planning · Pillar guide
FTE Workforce Planning: From Workload to Scheduled Staff
Convert workload hours into productive FTEs and adjust for meetings, training, leave and other shrinkage.
Workforce Planning · GuideStaffing Shrinkage: Divide by Availability
Divide the productive staffing requirement by one minus shrinkage. Ten productive FTE at 20% shrinkage requires 12.5 scheduled FTE, not 12.
Workforce Planning · GuideFTE vs. Headcount: Why Twelve People May Not Equal Twelve FTE
FTE expresses capacity relative to a full-time baseline. Headcount counts people. Part-time schedules make the two numbers differ.
Workforce Planning · GuideCalculate Weekly Coverage Hours Before Estimating Staff
Multiply simultaneous positions by operating hours. Two continuously occupied positions across a 24/7 week require 336 productive coverage hours.
Related calculators
Hours & Pay
Work Hours Calculator
Add clock-in and clock-out times, subtract breaks, and see regular and overtime hours.
Calculate →Payroll CalendarsPay Date Calendar
Generate weekly, biweekly, semimonthly or monthly pay dates for a selected year.
Calculate →Hours & PayShift Differential Calculator
Estimate extra pay from night, evening, weekend or other premium hours.
Calculate →Workforce PlanningShift Coverage & Gap Calculator
Compare shift rows against a constant staffing target and see exactly when coverage falls short.
Calculate →Turn the workload into comparable hours
Use the same time period for the workload and the full-time baseline. A requirement of 300 weekly hours divided by a 37.5-hour full-time week is 8 productive FTE. Do not divide weekly workload by annual employee hours. FTE is a capacity unit; it is not necessarily the number of people on the team.
Apply availability once, then check the roster
With 20% shrinkage, only 80% of scheduled capacity is available for the modeled work. Eight productive FTE therefore require 8 ÷ 0.8 = 10 scheduled FTE. A further 10% buffer gives 11. If leave and training were already removed from the baseline, do not deduct them again through shrinkage. Finally check skills and time-of-day coverage.
Frequently asked questions
How do you calculate FTE from hours?
Divide the hours in the chosen period by the hours that represent one full-time employee in the same period. Three people working 20 hours each equal 1.5 FTE on a 40-hour baseline.
Is 0.5 FTE half a person?
No. It is half of the selected full-time capacity. One employee working 20 hours on a 40-hour baseline supplies 0.5 FTE. Headcount still counts that employee as one person.
Why divide by one minus shrinkage?
At 20% shrinkage, 0.8 of scheduled hours remain productive. Dividing the productive requirement by 0.8 finds the scheduled capacity needed. Multiplying by 1.2 would understate that requirement.
Does enough FTE guarantee shift coverage?
No. Total capacity does not ensure enough people at each hour or the right skill mix. The result is a planning input, not a completed roster or a queueing-service-level model.
Continue with your own figures
Staffing Shrinkage and Productive Capacity Calculator — Estimate productive hours, the scheduled hours needed to cover demand, and the additional FTE required after unavailable time.
Work through a specific example
- Calculate FTE for a Team of Full-Time and Part-Time Employees — Add each group's scheduled weekly hours, then divide the total by one consistent full-time baseline. Count people separately: capacity and headcount answer different questions.
- Calculate a Staffing Capacity Gap Before Adding Headcount — A capacity gap is required hours minus available hours measured on the same basis. A positive number is a shortfall; a negative number is a surplus.
- Staffing Shrinkage Formula: Calculate Required Hours and FTE — Divide productive workload by the available fraction of scheduled time, then divide by the full-time baseline to estimate required FTE.
- Productive Hours vs Scheduled Hours in Workforce Planning — Scheduled hours show assigned time; productive hours show the portion available for a defined workload. Comparing demand with the wrong measure can hide a capacity gap.
Download the example input worksheet to copy the sample rows and record your assumptions.
Turn weekly hours into a staffing comparison
At a 40-hour full-time baseline, schedules of 40, 30 and 20 hours contribute 1.0, 0.75 and 0.5 FTE. Together they represent 2.25 scheduled FTE and three people. This conversion does not account for leave, training, meeting time or the placement of those hours on a roster.
Use the FTE conversion table to check individual schedules, then the staffing shrinkage calculator for unavailable-time assumptions. For round-the-clock demand, compare the 24/7 staffing scenarios and validate the roster in the coverage-gap calculator.
Worked examples for this calculator
Use these guides to check your inputs and understand the result before applying it to your own records.
Calculate Staffing from Work Volume and Handling Time
Turn task volumes and average handling times into workload hours, then compare them with productive capacity without double-counting shrinkage.
Measure the Capacity Impact of a Vacant Role
Estimate scheduled and productive hours lost to a vacancy, include temporary cover, and distinguish capacity gaps from salary savings.
New-Hire Training: Model the Capacity Ramp
Estimate a new hire’s contribution during onboarding, subtract mentor time once, and compare a weekly ramp with full-capacity assumptions.