Employee schedule template with total hours and overtime
Short answer
Hours for a shift = MOD(out - in, 1) × 24 - unpaid break hours. Weekly regular hours = MIN(40, total); overtime hours = MAX(0, total - 40); gross pay = regular × rate + overtime × rate × 1.5 under the US federal rule for non-exempt employees.
Copy-paste code
Weekly totals per employee (B total hours, C hourly rate)
Shift hours: =MOD(Out - In, 1) * 24 - BreakMinutes / 60
Regular hours: =MIN(40, B2)
Overtime hours: =MAX(0, B2 - 40)
Gross pay: =MIN(40, B2) * C2 + MAX(0, B2 - 40) * C2 * 1.5Good to know
Some states (for example California) also require daily overtime and double time; this formula covers only the federal weekly rule. General information, not legal or payroll advice.
Hoursprig: Hours, overtime and pay, worked out
from $15Hoursprig works out hours, overtime and pay from time cards and prints a signable timesheet, all in your browser; Pro adds every employee, a payroll CSV and every overtime rule.
Secure checkout · 14-day fix-or-refund if it doesn't work as described (terms)Questions
Are breaks paid?
Under federal rules, short breaks (usually 5-20 minutes) are paid; bona fide meal periods of 30 minutes or more can be unpaid.
How do I round punches?
Follow a consistent, neutral rounding policy; many businesses avoid rounding entirely.
Free: the Small Business Starter Kit
Bookkeeping and profit previews plus free invoice, rent receipt, margin and HACCP/allergen tools, then 5 short emails on margins, invoicing and checklists.