Know exactly what you should be paid.
Type in your start and finish times. The Timesheet & Pay Calculator works out your hours, breaks, night shifts and overtime, then tells you if your paycheck adds up.
✓ One-off payment ✓ Instant download ✓ Excel for Windows & Mac
| Date | Day | Start | Finish | Break (mins) | Hours | Past midnight? | Overtime | Pay ($) |
|---|---|---|---|---|---|---|---|---|
| 08 Sep 2026 | Tue | 09:00 | 17:30 | 30 | 8:00 | – | 100.00 | |
| 11 Sep 2026 | Fri | 09:00 | 17:30 | 30 | 8:00 | – | 100.00 | |
| 12 Sep 2026 | Sat | 10:00 | 14:00 | 4:00 | 4.00 | 75.00 | ||
| 14 Sep 2026 | Mon | 22:00 | 06:30 | 30 | 8:00 | Yes | – | 100.00 |
| 15 Sep 2026 | Tue | 22:00 | 06:30 | 30 | 8:00 | Yes | – | 100.00 |
| 18 Sep 2026 | Fri | 22:00 | 07:00 | 45 | 8:15 | Yes | 0.25 | 104.69 |
| 21 Sep 2026 | Mon | 07:00 | 19:00 | 60 | 11:00 | – | 137.50 | |
| 24 Sep 2026 | Thu | 07:00 | 19:00 | 60 | 11:00 | 4.00 | 162.50 |
Working out your pay is harder than it should be
Night shifts break the maths
Take 22:00 away from 06:00 and a normal formula gives you -16 hours. This calculator gets it right: 8 hours.
Overtime is confusing
Does it start after 8 hours in a day, or 40 in a week? At time and a half, or double? Keeping track by hand is where mistakes happen.
Paychecks are hard to check
Two missing hours of overtime a month at time and a half is over $450 a year on $12.50 an hour. Most people never notice.
Three steps. No formulas to write.
Add your pay details
Enter your hourly rate once, and choose how your overtime works: none, daily or weekly, at any rate.
Enter your shifts
Date, start time, finish time and any unpaid break. Night shifts that finish after midnight are handled for you.
See what you’re owed
Your hours, overtime and pay add up automatically by week, by month and by pay period. Then check your paycheck.
Spot underpayments in seconds
Pick how often you’re paid (weekly, biweekly, semi-monthly, every 4 weeks or monthly) and the date the pay period starts. The calculator shows what your gross pay should be. Type in the figure from your pay stub and it tells you straight away if something’s missing.
- Regular pay and overtime pay shown separately
- Works with any pay period your employer uses
- Clear result: matches, more than expected, or less
PAY PERIOD
WHAT YOU SHOULD BE PAID
CHECK YOUR PAYCHECK
Night shifts that just work
Start at 22:00, finish at 06:30, take a 30-minute unpaid break, and it counts 8 hours. No formulas to fix, no minus numbers, no adding 24 by hand.
- Shifts past midnight are handled and clearly marked
- Unpaid breaks taken off automatically
- Hours shown as 8:15 and 8.25, whichever your employer uses
| Start | Finish | Break (mins) | Hours (h:mm) | Hours (decimal) | Past midnight? |
|---|---|---|---|---|---|
| 22:00 | 06:30 | 30 | 8:00 | 8.00 | Yes |
| 22:00 | 07:00 | 45 | 8:15 | 8.25 | Yes |
| 07:00 | 19:00 | 60 | 11:00 | 11.00 | |
| 08:40 | 17:20 | 20 | 8:20 | 8.33 |
Overtime and totals, worked out for you
Set your overtime rule once: after 40 hours a week (the standard US rule), after 8 hours a day, or none. Choose time and a half, double time or any rate. Every shift’s overtime is calculated and highlighted, and your weekly and monthly totals update as you type.
- Weekly Summary for up to 60 weeks
- Monthly Summary with a pay chart
- Your week can start on any day
| Week commencing | Shifts | Hours | Regular | Overtime | Gross pay ($) |
|---|---|---|---|---|---|
| 07 Sep 2026 | 6 | 44:00 | 40.00 | 4.00 | 575.00 |
| 14 Sep 2026 | 5 | 40:15 | 40.00 | 0.25 | 504.69 |
| 21 Sep 2026 | 5 | 48:00 | 40.00 | 8.00 | 650.00 |
Made for people paid by the hour
Shift workers
Care, healthcare, warehouse, hospitality, retail, security, factory work. Anyone doing days, lates or nights who wants to be sure they’re paid right.
Part-timers & second jobs
Hours that change every week are easy to lose track of. Keep one file per job and know what each one should pay.
Small employers
Keep a simple, clear record of hours and overtime for each member of staff. Save a copy of the file for each employee.
Everything you get
- Timesheet with room for 400 shifts (more than a year)
- Night shifts past midnight and unpaid breaks handled
- Daily or weekly overtime at any rate
- Weekly Summary and Monthly Summary with pay chart
- Pay Period Check: weekly, biweekly, semi-monthly, every 4 weeks or monthly
- Paycheck checker
- Works with any currency: $, $, €, ₹
- Formulas locked so they can’t be broken by accident
- Start Here guide and example shifts to learn from
One-off payment. Yours to keep.
Get instant access $9.99Secure checkout by Payhip · Card or PayPal
Download link emailed straight away
Hi, I’m Lee
I’ve been using Excel since school, and I run Sheet Leveller on YouTube, where I make quick, no-nonsense Excel tutorials. My video on calculating pay hours in Excel has been watched more than 779,000 times.
This calculator takes everything from those videos (time maths, night shifts, overtime) and puts it into one ready-made spreadsheet, so you don’t have to build it yourself.
Questions
Which versions of Excel does it work with?
Microsoft 365, Excel 2010 or later on Windows, and Excel for Mac. It’s built for Microsoft Excel.
Do I need to be good at Excel?
No. You only type in the yellow cells: dates, times and breaks. Everything else is worked out for you, and there’s a Start Here guide inside.
My shift finishes after midnight. Which date do I use?
The date the shift started. The calculator knows a 22:00 to 06:00 shift is 8 hours.
Does it work out taxes?
No. It shows your gross pay: what you should earn before taxes and other deductions. That’s the figure to check on your pay stub.
Can I use it for more than one person or job?
Yes. Save a separate copy of the file for each employee or each job.
What if my hourly rate changes?
Changing the rate in Settings updates every shift in the file. When you get a pay rise, start a fresh copy from that date so your older shifts keep the old rate.
Is this a subscription?
No. You pay once and the file is yours to keep.
How do I get it after paying?
You can download it straight away after checkout, and a download link is emailed to you too.
Stop guessing. Know what you’re owed.
Every shift, every overtime hour, every paycheck, checked in one simple spreadsheet.
Get the calculator $9.99Not ready yet? Try the free Hours & Pay Calculator.