Time & date calculator

Timesheet Calculator

Calculate hours worked from clock-in and clock-out times across a week, two weeks, or a month — with unpaid-break deduction, automatic overnight-shift handling, decimal and hours:minutes totals, optional overtime, and an Excel export.

Weekly, biweekly & monthly Decimal + h:m totals Excel export

Runs entirely in your browser — nothing you enter is stored or sent anywhere.

Period

Defaults to this week’s Monday.

$

Leave blank to skip pay calculations.

Daily time entries for the selected period
DateTime inTime outBreak (min)Worked
Mon Jan 5, 20267h 30m
Tue Jan 6, 20267h 30m
Wed Jan 7, 20267h 30m
Thu Jan 8, 20267h 30m
Fri Jan 9, 20267h 30m
Sat Jan 10, 20267h 30m
Sun Jan 11, 20267h 30m

Period totals

Total worked

52h 30m

52.50 decimal hours

Period

7 days

From Jan 5, 2026

How this calculator works

Per day

worked = (clock out − clock in) − break

Clock-out at or before clock-in is treated as an overnight shift, adding a day first.

Per period

total = Σ worked, across every day in the period

Shown as decimal hours and as hours:minutes, plus regular/overtime split and pay if you set a rate.

Every day in the grid is independent — there’s no requirement that every day have the same clock-in and clock-out, which is what makes this a real timesheet rather than a single shift multiplied by a day count. Switching the period preset (week / two weeks / month) changes how many day-rows are shown; changing the start date relabels the calendar dates without disturbing the times you’ve already entered.

Worked example

A five-day week, each day 9:00 AM in with a 30-minute lunch, clocking out at different times:

Worked example: a five-day week with one long day
DayInOutBreakWorked
Monday9:005:30 PM30 min8h 0m
Tuesday9:005:30 PM30 min8h 0m
Wednesday9:007:00 PM30 min9h 30m
Thursday9:005:30 PM30 min8h 0m
Friday9:005:00 PM30 min7h 30m

Adding the five days: 8:00 + 8:00 + 9:30 + 8:00 + 7:30 = 41 hours 0 minutes (41.00 decimal hours). With overtime set to “after 40 hours” at a 1.5× multiplier, that’s 40 hours regular plus 1 hour overtime. At a $20/hour rate: 40 × $20 = $800 regular, 1 × $20 × 1.5 = $30 overtime, for $830 total.

Overnight shift

A night-shift row clocking in at 10:00 PM and out at 6:00 AM, with a 30-minute break: the clock-out time (6:00 AM) is earlier than the clock-in time (10:00 PM), so the calculator treats it as crossing midnight — span = (6:00 AM next day) − 10:00 PM = 8 hours, minus the 30-minute break = 7 hours 30 minutes.

Overtime and pay, explained

Overtime rules vary enormously — by country, by US state, and often by employer or union agreement. Rather than guess at a specific jurisdiction’s rules, this calculator implements the one model that’s close to universal: a single hour threshold for the whole period (commonly 40 hours for a week), with hours above it paid at a multiplier (commonly 1.5×, sometimes called “time and a half”). It does not implement day-based overtime (for example, some jurisdictions pay overtime after 8 hours in a single day even within a 40-hour week), double-time bands, or any region’s specific statutory rules. Leave overtime off entirely if your situation doesn’t fit this simplified model, and treat the result as a planning estimate to check against your employer’s actual payroll calculation either way.

Limitations

  • Weekly-threshold overtime only. No day-based, double-time, or jurisdiction-specific overtime rules — see “Overtime and pay” above.
  • No employer rounding policies. Some employers round clock times to the nearest 6, 10, or 15 minutes; this calculator uses your entered times exactly, to the minute.
  • One break field per day. Multiple unpaid breaks in a single day need to be added together into that day’s single “Break” number.
  • Not a substitute for a mandated timesheet system. Programs or employers with their own required electronic timesheet system (for example California’s IHSS EVV system) still need to be completed through that system directly.

Sources and methodology

Hours calculation: plain arithmetic on clock times — (clock out − clock in) − unpaid break, per day, summed across the period. No external data source is needed for the arithmetic itself.

Overtime concept: the optional weekly-hours-threshold-and-multiplier model mirrors the structure of the US Fair Labor Standards Act’s federal overtime standard (time-and-a-half after 40 hours in a workweek) as the single most widely recognized reference point — used here as a configurable, generic model, not as US-specific legal guidance.

Related calculators

Frequently asked questions

How does this timesheet calculator work?

Pick a period length (one week, two weeks, or a month), then enter a clock-in time, a clock-out time, and any unpaid break for each day. The calculator subtracts the break from the clock-in-to-clock-out span for every day, then adds every day together for a period total — shown in both decimal hours and hours:minutes.

How are decimal hours calculated?

Decimal hours are minutes worked divided by 60, rounded to two decimal places — 7 hours 30 minutes becomes 7.5, and 8 hours 15 minutes becomes 8.25. Payroll systems that pay per fraction of an hour (rather than to the exact minute) generally use this decimal form.

How do I account for a lunch break or other unpaid time?

Enter the unpaid minutes in that day’s "Break" field — it’s subtracted from the clock-in-to-clock-out span before the worked total is calculated. If a day has more than one unpaid break, add their minutes together into a single number for that day.

Can I use this for a biweekly or monthly pay period?

Yes — the period selector switches the grid between 7 rows (weekly), 14 rows (biweekly), and 30 rows (roughly a month). Every row still works the same way, and the period total adds all of them together regardless of length.

What happens if a shift crosses midnight (an overnight shift)?

If the clock-out time is earlier than or equal to the clock-in time, the calculator treats it as an overnight shift and automatically adds a day to the clock-out time before subtracting the break — no separate checkbox needed. A ⏭ marker next to the row’s total flags that it was treated this way, so you can double-check it matches what you meant.

How does the overtime calculation work?

Overtime here is a single, optional threshold applied to the whole period: hours above the threshold you set (commonly 40 for a week) are paid at the multiplier you set (commonly 1.5×), and everything up to the threshold is regular time. This is the simplified, widely-recognized weekly-overtime model — it does not implement day-based overtime (for example, "over 8 hours in a single day") or any specific state or country’s exact rules.

Does this apply my state’s, country’s, or employer’s specific overtime rules?

No. Overtime law and policy vary enormously by jurisdiction and by employer — daily thresholds, weekly thresholds, double-time bands, and industry-specific exceptions all differ. This calculator applies only the simple threshold-and-multiplier model you configure. Confirm your actual pay against your employer’s payroll system or your local labor authority.

Can I export my timesheet to Excel?

Yes — "Download Excel" saves every day’s clock-in, clock-out, break, and worked time, plus the period totals (and pay, if you entered an hourly rate), as a spreadsheet file you can keep or forward.

Does this replace my employer’s timesheet system, or a program like IHSS?

No. This is a general-purpose, browser-only calculator for working out hours yourself — it does not submit, store, or transmit anything to an employer, payroll provider, or a government program. Programs with their own mandated electronic timesheet or time-and-attendance system (for example California’s IHSS, which requires its own EVV system) still need to be completed through that system directly; use this tool only as your own scratch-pad calculation alongside it.

Is this legal, tax, or payroll advice?

No. It’s an educational calculator that applies the arithmetic you’d otherwise do by hand or in a spreadsheet. For anything that affects your actual pay, benefits, or legal entitlements, confirm with your employer’s payroll department or a qualified professional.

Does this store or send my time entries anywhere?

No. Every calculation runs in your own browser. Nothing you type into the grid is sent to or stored on our servers — the Excel export is generated and downloaded directly by your browser.

Can I print my timesheet?

Yes — the Print button opens your browser’s print dialog with the current grid and totals. For a keepable file rather than a printout, Download Excel is usually more useful.

What’s the difference between decimal hours and hours:minutes format?

They’re the same duration written two ways. Hours:minutes (7h 30m) is how most people read a clock; decimal hours (7.50) is how most payroll and billing systems store and calculate pay per fraction of an hour. This calculator always shows both so you can use whichever your situation calls for.

Does the calculator care what time zone I’m in?

No — a timesheet is a set of plain calendar dates and clock times, not a specific instant in time, so this calculator doesn’t do any time zone conversion. If you need to convert a specific date and time between time zones, use the separate Time Zone Converter instead.

Time & date disclaimer

This calculator applies simple, transparent arithmetic to the clock times, breaks, and rate you enter — it does not implement your employer’s specific overtime, rounding, or payroll rules, or any particular jurisdiction’s overtime law, and it is not a substitute for a mandated timesheet or time-and-attendance system your employer or a program you’re enrolled in requires. Confirm anything that affects your actual pay against your employer’s payroll system or a qualified professional.

How we calculate · email us

Authorship & verification

Written and maintained by

  • Formula and examples verified on 5 August 2026
  • Educational estimate only

Add this calculator to your site

Responsive embed — and private: nothing your visitors type leaves their browser.