Skip to main content

Apply Rates for the Day Worked

Enable Use next-day rates after midnight when a timesheet line crosses midnight and the hours on each calendar day should use that day’s applicable rates. This can include different weekday, weekend or public-holiday rates. This is a formula setting. It works whether or not you use Shift Types, and applies across the formula’s rules.

Enable Next-Day Rates

  1. Select Smart Formulas > Configure and open an editable draft.
  2. Select the formula name to open Smart Formula Details.
  3. Beneath Period, enable Use next-day rates after midnight.
  4. Select Save.
Period and next-day rates can be changed on an editable draft even when its identifying details are locked after first publication. Published versions show them read-only; create a new draft version to change them. Changing Period also checks that the existing rules fit the new assessment period.

How Hours Are Calculated

Hours before midnight use the original day’s applicable rules. Hours after midnight use the following calendar day’s applicable rules, including public-holiday rules when that date is a public holiday. Daily hour-band position continues across the shift; it does not restart at hour zero. For example, if a shift has worked four hours by midnight, the next hour is its fifth hour. Crossing midnight does not reset an eight-hour daily overtime threshold. Weekly overtime still uses the assessment period’s accumulated hours. Hours that reach the weekly threshold are paid through the weekly rules rather than paid again as next-day daily hours. If you use shift types, the selected type stays the same across the whole shift. Midnight changes the calendar day used for rates, not the shift type. Ensure your rules cover the required days and hour ranges, and any specific shift types. If the next day’s setup leaves hours uncovered, validation reports an incomplete setup rather than treating those hours as paid.

Simple Examples

Friday Night into Saturday

Consider a 20:00 Friday–02:00 Saturday shift with no breaks. Configure rules that cover the full shift, with Friday hours at 1.5× and Saturday hours at 2×, and enable next-day rates. The six-hour shift produces four hours at the Friday rate and two hours at the Saturday rate. The Saturday portion starts at the shift’s fifth hour for daily hour-band rules. You do not need shift types for this setup.

Daily Overtime Continues Across Midnight

Consider a 20:00–06:00 shift with no breaks and a daily ordinary-hours band covering the first eight hours. Configure the next day’s ordinary and overtime rules to cover the remaining hours. By midnight, four hours have been worked. The next four hours, from 00:00–04:00, complete the eight-hour ordinary band using the next day’s applicable rates. The last two hours, from 04:00–06:00, fall into the next day’s daily overtime band. The shift totals ten paid hours.

A Shift Continues into a Public Holiday

A line runs from 22:00–02:00, and the following date is a public holiday. With next-day rates enabled and suitable rules configured, the first two hours use the original day’s rates and the last two use the public-holiday rates. If the line is classified as Night, both parts remain Night.

Check Your Setup

Use Simulate before publishing and assigning the formula. Check a normal midnight crossing, a weekend or public holiday, and a shift crossing a daily or weekly overtime threshold. To test a shift crossing into a public holiday, add a simulator line on the following date and set its day type to Public Holiday. That marks the date as a holiday for the hours after midnight on the earlier line too. The added line needs valid start and end times, and its hours are also included in the simulation. If validation reports an incomplete setup, review the following day’s rules, their time or hour ranges and any shift-type selections.