Hourly timesheet template

Everhour embeds time tracking in work tools, while hourly records still need clean totals, break handling, and payroll-ready review.

How much did you earn this week?

Enter your daily hours and rate to instantly calculate total hours, regular pay, and any overtime — no spreadsheet needed.

$
Weekly gross pay
Regular hours40h
Overtime hours0h
Regular pay$1,400.00

Everhour does it all — track, budget, report & invoice

The calculator gives you the number — Everhour takes it from there.

Go ahead — start tracking!

One click and you're timing. Start a timer, add an entry, edit the details. This is exactly how it feels in Everhour.

  • One-click timer — browser, desktop & mobile
  • Works inside Asana, ClickUp, Linear, GitHub & more
  • Simple setup, no learning curve
Works with your favorite tool:
Everhour — Time Tracking
Time Entries
01:24:00
00:31:00
01:07:00

No more budget surprises

Set a budget, assign rates, and get alerted before you're over.

  • Real-time cost tracking
  • Set different rates per person or project
  • Alerts before you hit the budget limit
Everhour — Budgeting
Acme Web Project
1
50% of budget used
$2,500.00of $5,000.00
$2,500.00 remaining
75%
Actual costRemaining cost

Measurement

Track your budget through time or costs

Simple, customizable reports

Every report you need — configured your way, always up to date.

  • See who does what in real time
  • Configure any report
  • Scheduled email reports
Everhour — Reports

Your invoice is ready!

Tracked hours flow straight into a polished invoice — no copy-paste, no manual math.

  • Billable hours straight into the invoice
  • Configure invoice templates
  • Copy invoices to QuickBooks or Xero
  • Invoicing dashboard with status
Everhour — Invoices
Your Company LLChello@yourcompany.com
INVOICE
Invoice #1042
Group by:
DescriptionHoursRateAmount
Website Redesign14h$150/h$2,100.00
Brand Guidelines7h$150/h$1,050.00
Marketing Strategy3.5h$150/h$525.00
Total Due$3,675.00
Try Everhour for real yourself

Building an hourly work record

What this calculation answers

An hourly timesheet answers three practical questions: how long the person was on the clock, which breaks count as unpaid time, and whether the final weekly total creates overtime. The template needs separate fields for date, clock-in time, clock-out time, unpaid meal time, paid hours, hourly rate, and notes. In U.S. records, the common input pattern is month/day/year with 12-hour AM/PM times.

The result matters before payroll, invoicing, job costing, and manager approval. A clean template separates hours actually worked from paid time not worked, because different reports use those figures differently. For covered nonexempt employees in the United States, the federal baseline requires overtime after 40 hours worked in a fixed FLSA workweek, which is 168 fixed hours and cannot be averaged with another week.

Set the template columns

A practical hourly template should not hide break logic inside one total column. Use one column for gross span, one for unpaid meal time, and one for paid work time. Short breaks provided by an employer, usually about 5 to 20 minutes, are compensable hours worked under federal law and stay inside the paid total. A bona fide meal period is generally unpaid only when the employee is completely relieved from duty.

Add a notes column for edits, missed punches, pre-shift work, and post-shift work. Hours worked include required duty time and additional work the employer allows or permits, including unscheduled work before or after a scheduled shift. Federal time-clock rounding is accepted only when rounding to the nearest 5 minutes, tenth, or quarter-hour averages out over time and does not underpay actual hours worked.

Run the weekly formula

Start with each day's gross span, subtract unpaid meal periods that meet the relieved-of-duty test, then add the daily paid totals inside the same fixed workweek. For covered nonexempt employees, split the weekly total into regular hours up to 40 and overtime hours over 40. FLSA overtime is paid at not less than 1.5 times the employee's regular rate of pay for overtime hours.

For example, a covered nonexempt employee records 48 gross hours in one fixed workweek, takes 4 hours of bona fide unpaid meal periods, and earns $22 per hour. Paid hours are 44. Regular pay is 40 hours times $22, or $880. Overtime is 4 hours times $33, or $132. Total gross pay is $1,012 before taxes, deductions, reimbursements, or any state-specific premium-pay rule.

Calculator versus managed workflow

A one-off template is enough when you need a quick estimate, a single corrected week, or a simple pay preview before the official payroll run. It works best when one person controls the inputs and the rules are already known. It stops being enough when multiple employees edit entries, managers approve time, breaks need review, or payroll needs an audit trail.

A managed workflow gives the template a source of truth. Everhour can embed tracking controls inside supported project tools, sync project and task metadata, and expose timesheets inside the work tools teams already use. That matters when hourly entries feed billing, budgets, approvals, or payroll handoff, because the record comes from tracked activity instead of a spreadsheet rebuilt after the fact.

This content is for general information only, may not be fully up to date, and is provided without any warranty or liability.

High Performer

G2

Summer 2026

Best Ease Of Use

Capterra

Summer 2026

Loved by teams. Proven everywhere.

Rated in the top time trackers across G2, Capterra, and TrustRadius — with consistent praise for ease of use, integrations, and support.

10K+Teams worldwide
90K+Installs Everhour extension
196M+Tasks completed
4M+Projects tracked

Frequently Asked Questions

Which columns belong in an hourly timesheet?

An hourly timesheet needs date, employee name, clock-in time, clock-out time, unpaid meal time, paid hours, hourly rate, approval status, and notes. Payroll-facing templates should also keep the workweek clear, because covered nonexempt employees in the United States receive federal overtime based on hours worked over 40 in one fixed workweek.

Should an hourly template subtract lunch automatically?

Automatic lunch subtraction is safe only when the meal period is actually unpaid under the applicable rule. Under the federal baseline, a bona fide meal period is generally unpaid only when it lasts 30 minutes or more and the employee is completely relieved of duty. Work performed while eating remains hours worked.

How should a template handle AM and PM times?

A U.S. hourly template should accept the month/day/year date format and 12-hour AM/PM times. Each row should convert the clock-in and clock-out span into hours, then subtract only unpaid meal time. A shift that crosses midnight needs the end time assigned to the next calendar date so the span does not turn negative.

Does an hourly timesheet template decide overtime rules?

A template calculates hours and pay after you enter the rule. For covered nonexempt employees in the United States, the federal baseline is overtime after 40 hours worked in a fixed 168-hour workweek at not less than 1.5 times the regular rate. State law, employer policy, or a contract can add stricter requirements.

Can rounded entries be used in an hourly record?

Rounded entries can be used only when the rounding practice is neutral over time and does not underpay employees for actual hours worked. Federal rules accept rounding to the nearest 5 minutes, tenth, or quarter-hour under that condition. A template should preserve the original punch times when payroll or managers need to review the rounding result.

How does Everhour connect hourly timesheets with work tools?

Everhour integrates with tools such as Asana, ClickUp, GitHub, Jira, Monday, Notion, Trello, QuickBooks, and Xero, then embeds tracking controls in supported workflows. Project and task metadata sync into Everhour, so timesheets can reflect the same work structure employees already use.

Move hourly records into Everhour

Track hourly work where it happens, then use Everhour integrations to connect approved timesheets with project context, accounting workflows, budgets, and cleaner payroll review.

14-day free trial  ·  No credit card  ·  Cancel anytime

Or