Turn a daily time record into payable hours: time in, time out, break, and scheduled start give you hours worked, the 8-hour regular/overtime split, minutes late, and a day-pay estimate. Handles overnight guard shifts (10 PM – 6 AM) correctly.
Hours worked, overtime, and tardiness from a daily time record — overnight-shift safe.
The arithmetic is simple — out − in − break, split at 8 hours, late minutes deducted — but multiply it by 30 guards × 30 days across a dozen posts and a few overnight shifts, and manual DTR processing becomes the slowest, most error-prone step of the payroll cycle. Every OT hour missed is underpayment; every phantom hour is margin lost, because what is on the DTR is also what gets billed to the client.
Time out minus time in, minus the unpaid meal break. An 8:00 AM–6:00 PM entry with a 1-hour break is 9 hours worked: 8 regular hours and 1 hour of overtime. For shifts that cross midnight (10:00 PM–6:00 AM), add 24 hours to the time-out before subtracting — this calculator does that automatically.
The DTR is the daily log of an employee's actual time in, time out, and breaks — the source document for payroll. For deployed personnel like security guards it is kept per post, and DOLE inspections and client billing disputes both come down to what the DTR says.
Hours worked beyond 8 in a workday are overtime, payable at 125% on an ordinary day (higher on rest days and holidays). The DTR establishes the count; the premium multipliers are applied in payroll.
Minutes late against the scheduled start are typically deducted at the basic hourly rate pro-rated by the minutes (rate ÷ 8 ÷ 60 × minutes late). Grace-period policies vary by employer — the deduction here assumes none.
It remains common, but paper DTRs from remote posts arrive late, get reconstructed from memory, and cause payroll errors and billing disputes. Electronic capture at the post — timestamped and geofenced — is the reliable version of the same record, and it is what modern agencies are moving to.
NexusWorkforce captures the DTR at the post itself — geofenced mobile clock-in, offline-capable for remote sites — and feeds it straight into payroll premiums and client billing. One attendance record, no re-encoding.
Book a DemoMore free tools: DTR + payroll Excel template (free download) · Holiday pay · Night differential · All free tools