Work out your hours and pay free.
A simple Excel calculator for your shifts. Type in your start time, finish time and any unpaid break, and it works out your hours and pay, even for night shifts that finish after midnight.
✓ 100% free ✓ Instant download ✓ Excel for Windows & Mac
| Date | Start | Finish | Unpaid break (mins) | Hours (h:mm) | Hours (decimal) | Pay ($) |
|---|---|---|---|---|---|---|
| 07 Sep 2026 | 09:00 | 17:30 | 30 | 8:00 | 8.00 | 100.00 |
| 08 Sep 2026 | 22:00 | 06:30 | 30 | 8:00 | 8.00 | 100.00 |
| 10 Sep 2026 | 07:00 | 19:00 | 60 | 11:00 | 11.00 | 137.50 |
| 12 Sep 2026 | 10:00 | 14:00 | 4:00 | 4.00 | 50.00 | |
| Total | 31:00 | 31.00 | 387.50 |
Simple, and it gets the tricky bits right
Night shifts sorted
22:00 to 06:30 with a 30-minute break is 8 hours, not -16 hours. No formulas to fix.
Breaks taken off
Enter your unpaid break in minutes and it’s taken off your hours automatically.
Hours and pay
See each shift as 8:15 and 8.25 hours, plus your pay, with totals for up to 31 shifts.
Yours in under a minute
Click “Download it free”
You’ll go to a secure download page. There’s nothing to pay.
Enter your email
The download link is sent straight to your inbox, and you can download it straight away too.
Open it in Excel
Type your hourly rate and your shifts in the yellow cells. That’s it.
Free version or full version
The free calculator is great for adding up your shifts. If you get overtime or want to check your paycheck, the full Timesheet & Pay Calculator does it all for you.
| Free | Full version · $9.99 | |
|---|---|---|
| Hours and pay for each shift | ✓ | ✓ |
| Night shifts past midnight | ✓ | ✓ |
| Unpaid breaks | ✓ | ✓ |
| Number of shifts | 31 | 400 |
| Daily or weekly overtime, any rate | – | ✓ |
| Weekly and monthly totals | – | ✓ |
| Monthly pay chart | – | ✓ |
| Pay Period Check (weekly to monthly) | – | ✓ |
| Paycheck checker | – | ✓ |
Hi, I’m Lee
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 free calculator puts those formulas into a ready-made spreadsheet you can start using today.
Questions
Is it really free?
Yes. You just enter your email address so the download link can be sent to you.
Will you email me?
Now and then, with new Excel templates and tips. You can unsubscribe at any time with one click.
Which versions of Excel does it work with?
Microsoft 365, Excel 2010 or later on Windows, and Excel for Mac.
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 pay before taxes and other deductions.
Stop doing shift maths by hand.
Download the free Hours & Pay Calculator and let Excel do it for you.
Download it freeGet overtime? See the full Timesheet & Pay Calculator.