FinanceFree · No signup

Excel Timesheet & Hours Calculator

Enter clock-in and clock-out times for the week. The calculator subtracts breaks, handles overnight shifts, splits hours above your threshold into overtime and shows the pay — plus the TIME formulas behind it.

Runs in your browserUpdated October 29, 2026Full-week timesheet · Overnight shifts · Overtime and pay built in

The short answer

An Excel timesheet calculator converts clock times into decimal hours with =(End−Start)*24, subtracts breaks and multiplies by the hourly rate. This calculator totals a full week, splits hours above the overtime threshold at 1.5×, and shows the MOD, SUM and SUMPRODUCT formulas needed to rebuild the timesheet in Excel.

Hourly rateGross pay before tax and deductions.Overtime after (hours)Weekly threshold — 40 is common in the US.Overtime multiplier1.5 = time and a half.

Weekly timesheet

Day	Start	End	Break (min)	Hours
Monday				8.00
Tuesday				8.00
Wednesday				8.00
Thursday				8.00
Friday				6.50
Saturday				0.00
Sunday				0.00
Total (5 days)				38.50

Total hours

38.50

Regular hours

38.50

At $22.00/hr

Overtime hours

0.00

At $33.00/hr

Gross pay

$847.00

Before tax and deductions

=(C2-B2)*24-D2/60

Hours for one row: end minus start, converted to decimal hours, then the unpaid break in minutes converted to hours. Use =MOD(C2-B2,1)*24-D2/60 when a shift crosses midnight.

=MIN(SUM(E2:E8),40)*G2+MAX(0,SUM(E2:E8)-40)*G2*H2

Weekly pay: regular hours capped at 40, overtime above it at 1.5×. Put the hourly rate in G2 and the overtime multiplier in H2, then format the result as Currency.

Why decimal hours? Excel stores 12:00 as 0.5 of a day. Multiplying the time difference by 24 converts it to the 8.00 format payroll systems expect. Keep the raw time cells formatted as hh:mm and the calculated hours as Number.

Overtime rules vary: some regions use a daily threshold, some require a weekly average, and salaried staff may be exempt. Check the rule that applies to you before using the figure for payroll.

How to use it

1Enter each day's start and end time in 24-hour HH:MM format.
2Add the unpaid break in minutes for each day.
3Set the hourly rate, weekly overtime threshold and overtime multiplier.
4Read the weekly hours, overtime split and gross pay, then copy the formulas into your timesheet.

Questions about the timesheet calculator

What is the Excel formula for hours worked?

Use =(B2-A2)*24 and format the result as a number. If a shift can cross midnight, use =MOD(B2-A2,1)*24 so the negative time becomes the correct overnight duration. Subtract a break with -D2/60 when the break is stored in minutes.

Why does Excel show 0.5 instead of 12:00?

Excel stores one day as the number 1, so 12 hours is 0.5. Either format the cell as Time ([h]:mm) or multiply by 24 to get decimal hours. Use [h]:mm rather than h:mm when a total can exceed 24 hours.

How do I calculate overtime in Excel?

For a weekly threshold, regular hours are =MIN(SUM(E2:E8),40) and overtime is =MAX(0,SUM(E2:E8)-40). Pay is regular hours × rate + overtime hours × rate × 1.5. Check your local rules — some places use a daily threshold instead.

How do I subtract a lunch break from hours worked?

If the break is in minutes, subtract break/60 from decimal hours or break/1440 from an Excel time value. This calculator does that automatically for every row, and clamps the result at zero so a long break cannot create negative hours.

Need it done for you?

Building a timesheet or payroll model for a grade?

We build time cards, overtime rules and payroll summaries with auditable formulas — and explain the logic your marker will ask about.

Get a fixed quote Ask on WhatsApp See pricing →

From $15/hr
Fixed quote before work starts
Free minor revisions
Human experts, not AI files

Related free tools

All tools →

Loan CalculatorCalculate monthly EMI, total interest and a full amortization schedule, and get the exact PMT, IPMT and PPMT formulas for Excel.Open tool →Formula ExplainerPaste any Excel formula and get a plain-English explanation of every function, range and nested step.Open tool →Formula CheckerCheck any Excel formula for syntax errors, wrong argument counts, approximate-match traps and #REF! errors.Open tool →

Keep reading

Excel Timesheet & Hours Calculator

Runs in your browserUpdated October 29, 2026Full-week timesheet · Overnight shifts · Overtime and pay built in

Day

Start

End

Break (min)

Hours

Monday

8.00

Tuesday

8.00

Wednesday

8.00

Thursday

8.00

Friday

6.50

Saturday

0.00

Sunday

0.00

Total (5 days)

38.50

Questions about the timesheet calculator

What is the Excel formula for hours worked?

Why does Excel show 0.5 instead of 12:00?

Excel stores one day as the number 1, so 12 hours is 0.5. Either format the cell as Time ([h]:mm) or multiply by 24 to get decimal hours. Use [h]:mm rather than h:mm when a total can exceed 24 hours.

How do I calculate overtime in Excel?

How do I subtract a lunch break from hours worked?