Loona Automation

Multiple-Employee Timesheet Calculator — Small Crew Payroll in Minutes

Running payroll for a small team? Line up everyone's hours and rates, and get per-employee overtime and one clean crew total.

In short: enter up to 10 employees with their weekly hours and individual rates; each person's overtime (over 40 hours at 1.5×) is calculated separately, then totalled into crew hours, crew overtime and total gross payroll, with print and CSV export.
Time Card CalculatorHours CalculatorOvertime CalculatorCalifornia Overtime CalculatorTime and a Half CalculatorMinutes to Decimal Hours Converter

Multiple-Employee Timesheet Calculator — Small Crew Payroll

Up to 10 employees: name, total hours this week, and each person's rate. Overtime (over 40 at 1.5×) is applied per employee, and the crew total is your payroll figure. Rows with 0 hours are ignored.

EmployeeHours this weekRate ($)Overtime hoursGross pay
——
——
——
——
——
——
——
——
——
——

How It Works — The Rule Behind This Calculator

Small employers usually fail payroll in the same two places: applying overtime to the crew's combined hours instead of each person's, and forgetting that one employee's quiet week cannot offset another's overtime. Federal law is per-employee and per-workweek: each worker's hours over 40 in the week earn 1.5× their rate, regardless of anyone else's schedule. This calculator enforces exactly that — one row per person, premium computed inside the row.

Two honest limits: this is a gross-pay estimator, not a payroll service — it does not withhold taxes, apply state daily-overtime rules (use the By State estimator for those five states), or handle salaried staff. And employee names you type stay in this page on your device; nothing is stored or sent anywhere when you close it, so download the CSV if you need the record.

Related Hours Tools

Frequently Asked Questions

Is overtime calculated per employee or on total crew hours?

Per employee, always. Overtime attaches to the individual worker's hours over 40 in a workweek at that worker's own rate — combining the crew's hours first would underpay anyone who personally passed 40.

What about employees who worked in two roles at different rates?

Use a blended rate: total the person's straight-time earnings across both roles and divide by their total hours — that weighted average is the regular rate overtime is based on. The Shift Differential Calculator shows the blended-rate method in detail.

Does this handle California crews?

Not the daily rules — this page applies the federal weekly rule. For California's daily overtime and double time, run each employee through the California Overtime Calculator, or check the By State estimator first.

Is my crew's data saved anywhere?

No. Names, hours and rates exist only in this open page on your device. Use the CSV download or print button for your payroll records before closing the tab.

How it works — the formula

Every row is scored independently, because overtime belongs to a person, not to a crew. Inside each row, the first 40 hours are regular and anything past 40 is overtime at 1.5× that employee's own rate. The crew totals at the top are then just the sums of the finished rows — employees paid, total hours, total overtime hours and total gross payroll — and rows left at zero hours are left out of every total.

The formula per employee: Regular hours = min(hours worked, 40). Overtime hours = max(hours worked − 40, 0). Row gross = (regular hours × rate) + (overtime hours × rate × 1.5). Crew totals = the sum over all rows with hours greater than zero.

Worked example

A three-person crew for one week: Alicia works 44 hours at $20 — 40 regular + 4 overtime — for $920.00. Ben works 38 hours at $16.50, all regular, for $627.00. Chen works 40 hours at $18 for $720.00. The summary shows 3 employees paid, 122.00 crew hours, 4.00 crew overtime hours and a total gross payroll of $2,267.00. Note that Ben's 2 unused hours do not cancel any of Alicia's overtime — the split is per person.

Frequently asked questions

What happens if I leave a row at 0 hours?

The row is skipped entirely: it shows a dash instead of figures and is not counted in employees paid, crew hours or gross payroll. Unused rows are how the same 10-row sheet serves a crew of three — no deleting required.

Can two employees have different hourly rates?

Yes — each row carries its own rate, and each row's overtime premium is 1.5× that row's rate. A $20 employee's overtime hour costs $30 while a $16.50 employee's costs $24.75, and the totals simply add the rows together.

How many employees can one sheet handle?

Ten rows. That covers most small crews in a single pass; for a larger team, run the sheet in two passes (for example by department) and add the two gross payroll totals together — each employee still only ever appears once, so no overtime is double-counted.

Can I export the crew sheet?

Yes. The Print button produces a clean copy for the payroll file, and the CSV button downloads one row per paid employee — name, hours, rate, overtime hours and gross pay — ready for a spreadsheet or to send to a bookkeeper.

What if someone worked exactly 40 hours?

All 40 are regular time and the overtime figure is 0.00. Overtime starts with the first minute past 40 in the week for that employee — 40.5 hours, for example, is 40 regular plus 0.5 at the premium rate.

Disclaimer: Estimates only — not payroll or legal advice. Your employer's payroll rules and state law control your actual pay. Figures are rounded for display; your pay stub and payroll department are the official record.

Embed this calculator on your website — free

Add this calculator to your own website or blog — it is completely free, needs no sign-up, and always shows the latest version. Copy the code below and paste it into your page where you want the calculator to appear. Keeping the small “Powered by Loona Automation” credit line under the embed helps keep this tool free — but you are free to style or remove it; the tool works either way.