Finance
Counting Shift Hours and Days Off: A Simple System for Small Teams
Arguments about hours at the end of the month almost always come from the same few gaps. Breaks were counted for some people and not others. A shift that ran past midnight was split two different ways. Or a sick day was written down as a day off. Fix three rules (how a shift is measured, how midnight is handled, and how absences are labelled) and the monthly totals stop being a negotiation.
How do you calculate the hours of a shift?
Hours worked = end time − start time − unpaid break. That's the whole formula. What matters is applying it the same way to everyone:
| Shift | Break | Hours |
|---|---|---|
| 09:00 – 17:00 | 30 min | 7h 30m |
| 13:00 – 21:00 | 30 min | 7h 30m |
| 11:00 – 23:00 | 60 min | 11h |
| 18:00 – 02:00 | 30 min | 7h 30m |
Decide once whether breaks are paid, write it down, and plan the break into every shift. Then the schedule already tells you the hours.
What about shifts that go past midnight?
Restaurants, bars, and bakeries all have them. The simplest rule is that a shift belongs to the day it starts. 18:00 to 02:00 on Friday is a Friday shift of 8 hours, minus its break. Don't split it into 6 hours on Friday and 2 on Saturday. That makes the person's week look odd and makes day totals hard to compare.
Day off, vacation, or sick: why label them?
"Not working" covers very different things, and they matter differently later:
- Day off: the regular weekly day the person doesn't work. Expected, repeats every week, nothing to count.
- Vacation: planned time away from days they'd normally work. Usually counted against an allowance over the year.
- Sick: unplanned absence. Worth tracking separately to spot patterns and for any rules that apply.
- Other: family events, personal reasons. Add a note so you remember why.
If everything is written as "off", you can't answer the simple question of how many vacation days someone took this year. Leave and sick-day entitlements depend on your country and your contracts, so check what applies to your team.
Planned hours vs. actual hours
A schedule gives you planned hours. People sometimes stay late, leave early, or swap. For many small teams, the honest approach is to treat the published schedule as the default and note only the exceptions as they happen. A late close or an early leave goes on the shift itself, so the monthly totals start right and only need small corrections.
A month-end routine that takes 15 minutes
- Make sure each week of the month was published and any changes were made in the schedule itself.
- Export each week's shifts with their hours.
- Add up the hours per person, and list vacation and sick days separately.
- Apply the noted exceptions, then run payroll from those numbers.
How YellowPOS helps
The YellowPOS staff schedule applies these rules for you. Every shift has a break in minutes, and its hours are end minus start minus break. A shift that ends earlier than it starts runs past midnight, is marked +1, and counts fully on the day it began. Absences are entered as Day off, Vacation, Sick, or Other leave, never as a blank cell. Each person's weekly total, including their leave days, sits at the end of their row, and each day's total sits at the bottom.
For payroll, export the week to Excel. The All entries sheet has one row per shift with the date, times, break, hours as a number, position, and status. Time off has its own rows with start and end dates. It's ready to add up per person in a few clicks.
YellowPOS doesn't record clock-in or clock-out times and doesn't calculate salaries. It gives you clean planned hours and a clear record of who was off and why, which is most of what month-end needs.
Frequently asked questions
How do you calculate the hours of a shift?
End time minus start time, minus any unpaid break. A 9:00 to 17:00 shift with a 30-minute break is 7.5 hours. Agree with your team whether breaks are paid, and apply the same rule to every shift.
How do you count a shift that goes past midnight?
Treat it as one shift that belongs to the day it started. 18:00 to 02:00 is 8 hours, or 7.5 with a 30-minute break, all counted on the start day. Splitting it across two days makes weekly totals confusing.
What is the difference between a day off and leave?
A day off is the regular, expected day someone doesn't work, usually the same day each week. Leave is time away from a day they would normally work, like vacation or sick days. Track them separately, because leave is what you usually need to count over the year.
Can YellowPOS calculate salaries from the schedule?
No. YellowPOS adds up planned hours per person, per day, and per week, and exports every shift with its hours to Excel. It does not record actual clock-in times or calculate pay. Use the Excel file as the starting point for your payroll.
Getting started
Write down your three rules (breaks, midnight, absence types) and share them with the team before next month starts. If you're still building the weekly schedule itself, start with how to build a weekly staff schedule.
Not on YellowPOS yet? Start your free trial and plan your first week of shifts.