Learn to Excel like a boss.
Quick, no-nonsense Excel tutorials, plus ready-made templates that do the hard work for you. Whether you’re new to Excel or already know your way around, there’s something here to save you time.
| 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 |
Ready-made spreadsheets that just work
Built from the formulas in my most popular tutorials, so you don’t have to build them yourself.
Timesheet & Pay Calculator
Hours, breaks, night shifts and overtime worked out for you, plus a paycheck checker to spot underpayments.
- Daily or weekly overtime at any rate
- Weekly and monthly totals with a pay chart
- Weekly, biweekly, semi-monthly or monthly pay
Hours & Pay Calculator
A simple calculator for your shifts. Enter your start time, finish time and break, and it works out your hours and pay, even for night shifts.
- Night shifts past midnight
- Unpaid breaks taken off
- Totals for up to 31 shifts
More templates on the way
Download the free calculator and you’ll be the first to hear when new templates are ready.
Most-watched tutorials
Short, to the point, and straight to the answer.
Guides and references
Hi, I’m Lee
I’m a Microsoft Excel enthusiast and I’ve been using it since my high school days. I started Sheet Leveller to share what I’ve learned, with quick, clear tutorials that solve real problems.
From calculating pay hours to colour-coded drop-downs, my videos have been watched more than 6.3 million times. More about me.
Level up your spreadsheets.
Quick new Excel tutorials on YouTube. Subscribe so you don’t miss one.
Subscribe on YouTubeOr start with the free Hours & Pay Calculator.