Find staffing gaps and overlaps in a repeating daily roster. Enter shift times and people counts, compare interval coverage and download a CSV.
For each minute in the coverage window, count people whose shifts include that minute. Missing person-hours = sum of max(0, required − scheduled) ÷ 60. Time below target counts each understaffed minute once.
Results depend on your inputs. Read the calculation methodology.
Need 2 people from 09:00–17:00. Two work 09:00–13:00 and one works 12:00–17:00. Coverage is sufficient until 13:00, then one person short for four hours: 4 missing person-hours. The 12:00–13:00 overlap provides 1 surplus person-hour.
Total staffing hours measure volume. Coverage measures whether enough people are available at the specific times demand occurs; surplus at one time cannot fill a gap later.
Workforce Planning · GuideRepresent each employee’s available work segments separately. Remove uncovered breaks from the roster before checking whether the simultaneous staffing target is met.
Convert workload hours into productive and scheduled full-time equivalents.
Calculate →Shift SchedulesGenerate a dated work/rest rotation and download an all-day calendar.
Calculate →Hours & PayAdd clock-in and clock-out times, subtract breaks, and see regular and overtime hours.
Calculate →Hours & PayCount working dates with custom weekdays and closures, then export a daily breakdown.
Calculate →Total paid hours can look adequate even when nobody covers a required interval. Enter the service window, a constant people requirement and your repeating daily shift rows. The breakdown merges adjacent minutes with the same coverage, making gaps and overlap visible. Missing person-hours measure the size of a gap; time below target measures how long any shortfall lasts.
Split a person’s assignment into separate rows before and after an uncovered break. Earlier end times cross midnight. Because this is a repeating daily model, an overnight shift also contributes its early-morning portion to the next daily cycle. For a one-off dated roster, changing weekday demand or skill-specific coverage, check those requirements separately.
No. Three people at noon cannot cover a missing person at 15:00. Surplus and missing person-hours are reported separately.
Use the same start and end time for the coverage window. Individual shift rows must have different endpoints; split a 24-hour assignment into two rows.
A person unavailable during a break should not count toward the target. Split that shift around the break and enter each available segment.
No. It is the maximum additional people needed at one moment under these inputs. Existing staff may be movable, and skills, labor rules or service-level requirements may change the solution.
Staffing Shrinkage and Productive Capacity Calculator — Estimate productive hours, the scheduled hours needed to cover demand, and the additional FTE required after unavailable time.