DTR Calculator: Late, Undertime, Overtime & Night Hours
Paste your time in and time out for the cutoff and get each day’s regular hours, late, undertime, overtime and night-differential hours, plus the totals for payroll.
Tool inputs stay in your browser · optional AI search sends your query
Good to know: Built for Philippine cutoffs: paste one line per day with your time in and time out (from a logbook, biometrics or a phone note). Each day is compared with your schedule: late = minutes after the scheduled time in (beyond the grace period), undertime = minutes before the scheduled time out, overtime = minutes after the scheduled time out (from the minimum you set), and night hours = time worked between 10:00 PM and 6:00 AM, which earns at least 10% night differential under the Labor Code (Art. 86). Night shifts that end the next day are handled. The unpaid break is taken off regular hours on days of 5 hours or more; night hours are not reduced, so subtract the break yourself if you take it between 10 PM and 6 AM. Hours only: turn them into pay with the overtime, night differential and late/undertime calculators. For a whole team or biometric files (ZKTeco and others), DTR & Timesheet Pro does this for every employee. Everything is computed in your browser.
How to use it (step by step)
- 1Set your schedule, unpaid break and your company’s grace period.
- 2Paste your time in and time out, one day per line (a label such as the date first is fine).
- 3Read each day’s late, undertime, overtime and night hours, and the cutoff totals.
- 4Use “Next step” to turn the overtime and night hours into pay.
Words to know
- DTR
- Daily Time Record: the list of your time in and time out for each workday.
- Undertime
- Leaving before your scheduled time out. It is usually deducted from pay, like being late.
- Night differential
- At least 10% extra pay per hour worked between 10:00 PM and 6:00 AM (Labor Code Art. 86).
- Grace period
- Minutes after the start time that your company does not count as late. Set by company policy, not by law.
Sources & methods
References checked November 10, 2026. Read each tool’s scope and assumptions before relying on its result.
Spotted a wrong result or an outdated rule? Report a mistake · How we check our tools · Get new tools by email