← Back to blog

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:

ShiftBreakHours
09:00 – 17:0030 min7h 30m
13:00 – 21:0030 min7h 30m
11:00 – 23:0060 min11h
18:00 – 02:0030 min7h 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

  1. Make sure each week of the month was published and any changes were made in the schedule itself.
  2. Export each week's shifts with their hours.
  3. Add up the hours per person, and list vacation and sick days separately.
  4. 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.

Get Started with YellowPOS Today

Be Part of the Leading Network of 1000+ Online Stores

Questions About YellowPOS?

Email us at yellow.tech.953@gmail.com

Need a Custom Solution?

Use Our Development Service. Click to Get a Quote

YellowPOS provides tools that help you build sites and online shops. Our builder allows small stores, service groups, and solo workers to create sites without coding. Results may vary based on your work, content, and setup. We do not promise sales or growth.

YellowPOS offers a full site builder with dashboard, online shop, QR tools, and menu tools. By using our service you agree to our Terms of Use, Privacy rules, and Cookies rules. We may send updates, new feature notes, or service alerts by email.