Excel can total hours, but overtime logs need fixed workweeks and clean rates. Everhour keeps the source time organized.
Calculate regular and overtime earnings based on your hours and rate. Supports standard time-and-a-half and double-time multipliers.
Total hours including overtime
Typically 40h/week
The calculator gives you the number — Everhour takes it from there.
One click and you're timing. Start a timer, add an entry, edit the details. This is exactly how it feels in Everhour.
Set a budget, assign rates, and get alerted before you're over.
Measurement
Track your budget through time or costs
Every report you need — configured your way, always up to date.
Tracked hours flow straight into a polished invoice — no copy-paste, no manual math.
An Excel overtime log answers one practical question: how much pay belongs to regular hours and how much belongs to overtime for a covered nonexempt employee in a specific workweek. Under the U.S. FLSA federal baseline, overtime applies after 40 hours in a fixed 168-hour workweek, and the overtime rate must be at least 1.5 times the regular rate.
Excel is useful when you need a visible table of dates, start times, end times, breaks, total hours, and pay results. The workbook still needs the right structure: one fixed workweek per calculation, no averaging across two or more workweeks, and separate treatment for vacation or holiday time not worked when policy, contract, or state law controls that pay.
Excel stores time as fractions of a day, so elapsed payroll hours usually follow the shape `(end time - start time) * 24`, with breaks subtracted before weekly totals are calculated. If the weekly total can exceed 24 hours, use an elapsed duration format such as `[h]:mm`; otherwise, Excel may display a long total as a clock time instead of total hours.
For the overtime split, the workbook can use a `MIN` structure for regular hours and an `IF` or `MAX` structure for overtime hours. For example, regular hours are capped at 40 under the federal baseline for covered nonexempt employees, while overtime hours are the portion above 40 in the same fixed workweek. The workbook handles math, but the payroll rule and workweek boundary still have to be entered correctly.
For a simple federal baseline example, assume a covered nonexempt employee works 43 hours in one fixed FLSA workweek at a $31.20 regular hourly rate. Regular pay is 40 hours times $31.20, which equals $1,248.00. Overtime hours are 3 hours, and the overtime rate is $46.80 because $31.20 times 1.5 equals $46.80.
The overtime pay is 3 hours times $46.80, or $140.40. Total gross pay for the workweek is $1,248.00 plus $140.40, which equals $1,388.40. Do not average that 43-hour week with a shorter week to remove the overtime. Each FLSA workweek stands alone, and more protective state rules, covered worker category rules, or contract terms can require a greater benefit.
An Excel log is enough for a one-off check, a small correction, or a payroll review where the hours are already approved. It is also a practical archive format because Excel can open CSV files directly, import text or CSV data, and save worksheet data back to CSV or TXT for another system.
A managed workflow is better when time needs approvals, budget checks, billing handoff, or a lasting system of record. Everhour Project Budgeting connects tracked time to hour-based or money-based budgets, recurring budget periods, and budget alerts, so overtime-heavy work can be reviewed before it overruns a project or client budget.
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
Rated in the top time trackers across G2, Capterra, and TrustRadius — with consistent praise for ease of use, integrations, and support.
Use columns for employee, work date, workweek start, start time, end time, unpaid break, daily elapsed hours, weekly total hours, regular hours, overtime hours, regular rate, overtime rate, regular pay, overtime pay, and total pay. For billing review, add project, client, billable time, billable amount, invoiced time, and uninvoiced amount when those fields exist in the export.
Excel treats time as a clock unless the cell is formatted as elapsed duration. A total such as 43 hours can display incorrectly if the format wraps after 24 hours. Use bracketed hour formatting such as `[h]:mm` for weekly totals, then convert to decimal hours when payroll math requires multiplication by the regular rate.
No. Under the FLSA federal baseline, each fixed 168-hour workweek stands alone for covered nonexempt employees. A 43-hour week and a 37-hour week cannot be averaged into two 40-hour weeks to avoid overtime. The calculation must split regular and overtime hours inside the workweek where the hours were worked.
No federal overtime premium applies merely because work occurs on Saturdays, Sundays, holidays, or regular days of rest. Under the FLSA federal baseline, the trigger is hours worked over 40 in the fixed workweek for covered nonexempt employees, unless a more protective state law, employer policy, union contract, or other agreement gives a greater benefit.
The most common mistake is mixing clock-time totals, payroll hours, and pay rates in the same formula without checking the format. Excel may display duration totals incorrectly after 24 hours, and a workbook can also misstate overtime if paid time not worked is treated as hours worked without checking the applicable policy, contract, state rule, or worker category.
Everhour Project Budgeting tracks project budgets in hours or money as time is logged, with recurring budget periods and email alerts at defined thresholds. That gives managers a budget signal before approved overtime turns into an unexpected project cost.
Everhour Reporting can export saved reports in CSV, Excel/XLSX, or PDF formats, with columns for employee, project, task, billable time, labor costs, invoiced amounts, and uninvoiced amounts. That gives the Excel workbook cleaner source data for payroll or billing review.
Track approved hours against project budgets before overtime becomes a surprise cost. Everhour connects time, recurring budgets, and budget alerts for clearer labor-cost control.
14-day free trial · No credit card · Cancel anytime
