Practical guide 3 min read
How to count business days between two dates
Count working days with the right weekends, public holidays and days off, and avoid the classic off-by-one mistake.
Live
Utility
Work Hours Calculator
Build a timesheet with overnight shifts, unpaid breaks and decimal-hour totals. Export your rows as CSV.
Your time, clearly
?
Choose your options to begin.
Excluded holidays and custom dates
How this calculation works
For each shift, subtract the unpaid break from elapsed clock time, then apply any chosen rounding. Regular and overtime hours are calculated from the total. Equal start and end times mean zero hours.
Worked examples
- A shift from 22:00 to 06:00 with a 30-minute unpaid break is 7 hours 30 minutes, or 7.5 decimal hours. An end time earlier than the start time finishes the next day.
- Five shifts from 08:00 to 17:00, each with a 30-minute break, come to 42 hours 30 minutes. With a 40-hour threshold that's 40 regular hours and 2.50 overtime hours.
Questions
How does rounding to the nearest 15 minutes work?
Each shift's time after its break is rounded to the nearest quarter hour: 8 hours 7 minutes becomes 8 hours, and 8 hours 8 minutes becomes 8 hours 15 minutes. Use whatever rounding your workplace's policy sets.
Is overtime counted per day or per week?
Across all the shifts you enter, above the threshold you set (40 hours to start). Some places also count overtime by the day, such as over 8 hours in California or British Columbia, which this calculator doesn't apply, so treat it as an estimate rather than a payroll figure.
Can I keep my timesheet?
Download CSV saves every shift with its break, net minutes and decimal hours, plus the total, ready to open in a spreadsheet.
Part of Date Calculator
Calculate date differences, business days, age, date offsets and work hours with custom workweeks, holiday calendars and CSV exports.
A little guidance