Skip to content
Search/
CyberMax › Answers

Employee schedule template with total hours and overtime

Updated 2026-11-16 · Small business, landlords and freelancers · by CyberMax

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.5

Good 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 icon

Hoursprig: Hours, overtime and pay, worked out

from $15

Hoursprig 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.

You get one email to confirm first. Then the kit, and 5 short emails over two weeks. One-click unsubscribe in every email; we never share your address.

Related answers

A staff schedule in Google Sheets that adds up hours and labour costBuild a weekly staff rota in Google Sheets: shift start and end, unpaid breaks, overnight shifts, weekly hours