Skip to content
TimesheetCalculator
Menu

DTR Calculator

Enter your schedule and daily time in and time out to get late minutes, undertime and hours rendered.

Your schedule

Late within this many minutes is not counted.

Paid hours per day: 8 h. Night shift? Enter it as it is, such as 10:00 PM to 7:00 AM.

Time in and time out

Copy each day from your DTR or bundy card. New days start with your schedule times.

  1. Late 0 min · Undertime 0 min · Rendered 8 h

  2. Late 12 min · Undertime 0 min · Rendered 7 h 48 min

  3. Late 0 min · Undertime 30 min · Rendered 7 h 30 min

  4. Late 5 min · Undertime 0 min · Rendered 7 h 55 min

  5. Late 240 min · Undertime 0 min · Rendered 4 h

Peso deductions (optional)

Results update as you type. Your entries are saved on this device only.

Hours rendered

35 h 13 min

35.22 decimal hours over 5 days worked.

Late (tardiness)
257 min
3 days
Undertime
30 min
1 day
Late + undertime
4 h 47 min
Absences
0
0 on paid leave

An estimate from the times you enter. Your company's rules on grace periods, rounding and deductions decide the final payroll figures.

Check your DTR before payroll does

Your Daily Time Record shows 8:12 AM one morning and 4:30 PM one afternoon. A week later, your payslip has a deduction for tardiness and undertime, and you want to know if the minutes are right. Doing it by hand is slow, and the lunch break is where most hand computations go wrong.

This calculator reads your schedule and each day's time in and time out. It gives the late minutes, undertime minutes and hours rendered for every day and for the whole period. If you add your salary, it also estimates the peso deduction. It does not decide your company's grace-period or rounding rules. You enter those, and the calculator applies them the same way to every day.

How to use the DTR calculator

Step 1

Set your schedule once

Enter your scheduled time in and time out, when your unpaid break starts and how long it is, and your company's grace period if it has one. For an 8:00 AM to 5:00 PM job with lunch from 12:00 to 1:00, that is 8 paid hours a day.

Step 2

Copy each day from your DTR

Enter the actual time in and time out for each day. Mark days you missed as Absent (unpaid) or Leave (paid) instead of leaving them blank. Each new day starts with your schedule times, so you only change what was different. Use Clear days to remove the sample week and start your own cutoff.

Step 3

Read the totals, then add pay if you need pesos

The result shows hours rendered, late, undertime and absences. Open Peso deductions and enter your monthly salary or daily rate to see the rate per minute and the estimated deduction.

Results update as you type, and your entries stay saved in this browser. You can come back each day, add the new day and keep a running total for the cutoff.

Example: one week with a half day

The calculator opens with this week already filled in. The schedule is 8:00 AM to 5:00 PM with a one-hour lunch at 12:00, and no grace period.

Example week of time in and time out with late, undertime and hours rendered
DayInOutLateUndertimeRendered
18:00 AM5:00 PM008 h
28:12 AM5:00 PM1207 h 48 min
38:00 AM4:30 PM0307 h 30 min
48:05 AM5:00 PM507 h 55 min
51:00 PM5:00 PM24004 h
Total2573035 h 13 min

Day 5 is the one to look at. The employee came in at 1:00 PM, five hours after 8:00 AM, but the late is 240 minutes, not 300. The lunch hour from 12:00 to 1:00 is unpaid, so it was never part of the 8 paid hours. Counting it as late would deduct an hour the employee would not have been paid for anyway.

Now add a ₱20,000 monthly salary on a Monday-to-Friday schedule.

Daily rate = ₱20,000 × 12 ÷ 261 = ₱919.54

Rate per hour = ₱919.54 ÷ 8 = ₱114.94

Rate per minute = ₱114.94 ÷ 60 = ₱1.9157 (₱1.915709… unrounded)

Late deduction = 257 × ₱1.915709 = ₱492.34

Undertime deduction = 30 × ₱1.915709 = ₱57.47

The week's estimated deduction is ₱549.81. The calculator keeps the rate per minute unrounded. If you multiply by the rounded ₱1.9157 instead, the late deduction comes out a centavo lower, at ₱492.33.

How late, undertime and hours rendered are computed

How each DTR figure is computed
FigureWhat it meansHow it is counted
Late (tardiness)Arriving after your scheduled time inPaid minutes from the scheduled time in to your actual time in. Zero if within the grace period.
UndertimeLeaving before your scheduled time outPaid minutes from your actual time out to the scheduled time out
Hours renderedPaid schedule time you actually coveredPaid hours in the schedule − late − undertime
AbsenceA scheduled day not worked and not on paid leaveOne whole day, valued at the daily rate

"Paid minutes" means minutes inside your schedule, minus your unpaid break. That is why arriving after lunch or leaving at lunch never counts the break itself.

Grace periods

Many companies forgive a few minutes, such as 10 or 15. The calculator treats a grace period this way: if you are late by no more than the grace minutes, late is zero. If you are later than that, all the late minutes count, starting from your scheduled time in. Some companies count only the minutes after the grace period. If yours does, subtract the grace minutes from those days by hand.

Coming in early or staying late

Time before your scheduled time in or after your scheduled time out is shown separately and is not added to hours rendered. Overtime has to be approved and is paid on its own terms. It also cannot cancel late or undertime on another day, as explained below.

Night shifts

Enter a schedule like 10:00 PM to 7:00 AM as it is. The calculator understands that the shift crosses midnight. A time in of 10:10 PM is 10 minutes late, and a time out of 6:30 AM is 30 minutes of undertime.

Rate per minute

For a monthly salary, the daily rate is the monthly salary × 12 ÷ the paid days your salary covers in a year: 261 for Monday to Friday, 313 for Monday to Saturday, or 365 if you are paid for every day including rest days. These are the factors in DOLE's handbook on statutory monetary benefits, but your company decides which one applies to you. The rate per hour is the daily rate ÷ your paid hours per day, and the rate per minute is that ÷ 60.

Can overtime cancel your late or undertime?

Not on another day. Article 88 of the Labor Code says undertime on any particular day shall not be offset by overtime on any other day. So if you were 30 minutes late on Monday and stayed an hour late on Tuesday, Monday's 30 minutes is still undertime, and Tuesday's approved overtime is still paid as overtime.

This calculator follows the same rule. It counts each day's late and undertime separately and never lets extra time on one day reduce another day's figures.

For OJT students tracking hours

If you are on OJT, the Hours rendered total is the number your coordinator usually asks for. Enter your internship schedule and copy your DTR, then put the total into the OJT Hours Calculator as hours already rendered. It will show how many hours are left and your projected last day. Some schools credit time beyond your schedule and some do not, so check before you count early arrivals.

Before you question a deduction

  • Use the times on your signed DTR or the biometric report, not times you remember.
  • Confirm your official schedule and break time with HR. A 12:30 lunch changes half-day computations.
  • Ask whether your company has a grace period and how it applies after the grace ends.
  • Check whether payroll rounds minutes, for example to the nearest 15. This calculator uses exact minutes.
  • Ask which daily-rate factor is used for your deductions. The wrong factor changes every peso figure.
  • Keep paid leave separate from absences. Approved paid leave should not be deducted.

Questions about the DTR

What is the difference between late and undertime?

Late, or tardiness, is time missed at the start of the day because you arrived after your scheduled time in. Undertime is time missed at the end because you left before your scheduled time out. Both are counted in minutes and usually deducted the same way.

How do I compute late in minutes?

Subtract your scheduled time in from your actual time in. 8:12 AM against an 8:00 AM schedule is 12 minutes late. If you arrive after an unpaid break, leave the break minutes out.

Why is my half day not counted as 4.5 or 5 hours late?

Because the unpaid lunch break is not part of your paid hours. Arriving at 1:00 PM on an 8 AM to 5 PM schedule with lunch from 12 to 1 is 240 minutes late, which is 4 paid hours.

Does a grace period remove all my late minutes?

Only when you are within it. With a 15-minute grace, 8:12 AM counts as on time, but 8:20 AM counts as 20 minutes late in this calculator. Check whether your company counts only the minutes after the grace period.

Can early time in make up for leaving early?

Not in this calculator. Time before your schedule is shown as extra time and does not reduce undertime, because payroll usually pays only the scheduled hours unless overtime is approved.

How is the rate per minute computed?

Divide your daily rate by your paid hours per day, then by 60. For a monthly salary, the daily rate is the salary × 12 ÷ 261, 313 or 365, depending on your schedule and company policy.

Should I mark a day off as absent?

Only scheduled workdays you missed without pay. Leave rest days and holidays out of the list. Mark approved paid leave as Leave (paid) so it is not deducted.

Does the calculator round minutes?

No. It uses exact minutes. If your company rounds late or undertime, for example up to the nearest 15 minutes, apply that rule to the daily figures.

Sources