Shift interval ruler with overnight wrap, break cutout, and regular/overtime thresholdLive current inputs
Date & Time
Timesheet Duration Calculator
Calculate paid shift duration, breaks, weekly regular and overtime hours, threshold crossing, and gross pay for overnight or daytime timesheets.
Paid hours per shift—
Total paid hours—
Regular hours in these shifts—
Overtime hours in these shifts—
Estimated gross pay—
Total unpaid break time—
Weekly hours after shifts—
Timesheet assessment—
Paid-duration interval ruler
Shift interval ruler with overnight wrap, break cutout, and regular/overtime threshold
Each shift is drawn as a clock interval with the unpaid break removed and overtime threshold crossing marked.
Live decision table
Shift-by-shift duration ledger
Reconcile clock duration, breaks, paid time, and overtime allocation.
| Shift | Clock interval | Unpaid break | Paid hours | Regular hours | Overtime hours |
|---|
Cash-flow schedule
Annual and monthly cash-flow schedule
How to use
Translate the requirement into dated work capacity
- Enter the actual planning start date.
- Use a sustainable overtime cap.
- Match the real workweek.
- Exclude known unavailable days.
Calculation logic
Capacity and calendar availability are separate constraints
Required workdays come from hours divided by daily capacity. Calendar span then accounts for nonworking days.
The schedule never assumes every calendar day is available.
Calculation method
Normalize overnight clock time, remove breaks, then allocate weekly threshold hours
An end time earlier than start is treated as next-day. Weekly prior hours determine where regular time ends.
Detailed calculation process and general formulas
Elapsed=(End-Start+24) mod 24Paid=Elapsed-Break/60Total=Paid·DOT=max(Prior+Total-Threshold,0) capped to TotalPay=Regular·w+OT·w·mSymbols, meanings, and units
- Elapsed
- clock duration including overnight rolloverhours
- Paid
- paid duration after breakhours/shift
- D
- shift countcount
- OT
- overtime hours in entered shiftshours
- w
- base wagecurrency/hour
Decision checks
Confirm policy and fatigue limits
- Local overtime law and approval.
- Rest periods and consecutive-day limits.
- Holiday and leave calendars.
- Payroll rounding and cutoff dates.
Schedule anatomy
What sets the completion date
Hours, daily capacity, workweek, and exclusions each affect timing.
Paid shift duration
—Clock time less unpaid break.
Overtime hours
—Entered-shift time above weekly threshold.
Gross pay
—Regular and premium pay combined.
Decision takeaway: Use the schedule as a capacity plan, then confirm approval and rest requirements.
Practical applications
Decisions this calculator is designed to support
Month-end backlog
A team allocates overtime across normal business days.
What the result clarifies: The calendar exposes whether the deadline is realistic.
Holiday week
One unavailable workday falls inside the plan.
What the result clarifies: The exclusion shifts the completion date instead of increasing daily load.
Worked example
Current-input substitution and reconciliation
Important note
This planning tool does not determine legal overtime, payroll entitlement, union rules, fatigue safety, or employer approval.
Timesheet Duration Calculator FAQ
Are weekends counted?
Only when the entered workdays per week includes them.
How are holidays handled?
The entered count removes the earliest scheduled workdays as a planning approximation.
Can the last day be partial?
Yes. The final day's planned hours are capped at the remaining requirement.