Crew Timesheet Template
Free crew timesheet template (Excel): many workers on one sheet, auto-totals, a federal 40-hour overtime split, and an optional estimated-pay column. No signup.
How the totals and overtime are computed
Each worker is one row; each day is one column. The sheet sums the day columns into Total hours, then splits Regular and Overtime using the federal 40-hour workweek convention, and — only if you enter an hourly rate — estimates gross pay:
total hours = Σ day hours
regular hours = min(week total, 40) ← per workweek
overtime hours = max(week total − 40, 0) ← per workweek
estimated pay = regular × rate + overtime × rate × 1.5
On the biweekly tab the overtime split is computed for each
of the two workweeks separately and then added — a worker with 45 hours one
week and 35 the next has 5 overtime hours, not 0. Leave the rate blank for an
hours-only sheet: no pay or $0 appears anywhere.
The 40-hour / 1.5× overtime rule is the federal Fair Labor Standards Act convention, shown here as a convenience. Overtime rules vary by state (some have daily overtime or seventh-day premiums) — confirm with your payroll provider. This is payroll prep, not a paystub or a certified payroll filing. Nothing is saved; there is no crew roster, no stored time history, and no clock-in/out.
Sources
- Free Excel Timesheet Templates. Smartsheet. Retrieved .
- Weekly Timesheet Template for Multiple Employees. ClickTime. Retrieved .
- Free Timesheet Templates (Excel, Word, Sheets). My Hours. Retrieved .
- Overtime Pay — Fair Labor Standards Act. U.S. Department of Labor. Retrieved .