DST Timesheet Review Worksheet

TimeTrex resources · Timekeeping review

One clock time can describe two different moments.

Review a daylight-saving shift using the original timestamps, then document what the evidence supports. This worksheet helps payroll reviewers choose a next action before changing a time record.

Evidence first · One punch pair per review
1. Choose the evidence you have

Choose the best description. This selects a review route; it does not validate timestamps or approve pay.

2. Capture the evidence pair

Use a case reference rather than an employee name or payroll identifier. These optional notes stay in this browser view; they are not saved or transmitted by the tool. Copy your completed record into your approved internal system before leaving.

No timestamp parser or automatic arithmetic runs here. The examples below explain the calculation; incomplete or contradictory notes must remain unresolved.

3. Check the correction packet

Checking a box records your statement. It does not prove compliance or replace review.

How to use the worksheet

Preserve the original, then identify the moment

Keep the full local date and time, numeric UTC offset, site time-zone identifier and source reference. A zone name gives context; the offset identifies how that event relates to UTC. A current offset alone does not establish the offset of an older event.

Normalize both endpoints before subtracting

UTC timestamp = local timestamp − signed UTC offset. Then subtract start UTC from end UTC. The date must move with any midnight crossing. RFC 3339 defines numeric offsets this way; see RFC 3339 §4.2. Do not treat an unknown offset as a verified zero offset.

Separate duration from the pay decision

Elapsed minutes describe the interval between events. They do not establish whether every minute was worked, whether a break was unpaid, or how overtime applies. For U.S. FLSA situations, the Department of Labor's clock-change example explains why actual work can differ from scheduled hours. Apply the rules covering your workforce.

Worked checks: the display is not the duration

These are illustrative timestamp pairs with explicitly assumed offsets. They do not assert that a particular place changes clocks on these dates. No breaks are deducted and no payable-hour result is implied.

Repeated local hour · Filled example

The clock says 01:30 twice. One hour elapsed.

Start: 2026-11-01 01:30 at UTC−04:00 → 05:30 UTC.
End: 2026-11-01 01:30 at UTC−05:00 → 06:30 UTC.

06:30 − 05:30 = 60 minutes

Handoff: Original offset-bearing log retained; interval checked as 60 minutes. Ask the authorized reviewer to confirm actual work and pay treatment. The two displays match, but they identify different moments.

Additional independent arithmetic checks
Illustrative endpointsUTC comparisonReview meaning
01:30 −05:00 → 03:30 −04:00, same date06:30 → 07:30; 60 minutesThe local display advances two hours; the elapsed interval is one.
23:30 −04:00 → next-day 00:30 −04:00Next-day 03:30 → 04:30; 60 minutesPreserve the date when crossing midnight.
01:30 −04:00 → 01:30 −04:00, same date05:30 → 05:30; 0 minutesSame instant; investigate pairing if a worked shift was expected.
01:30 → 01:30, no offsetsNot determinedEqual local displays cannot identify which repeated hour was recorded.

Exceptions to resolve before correction

The end is earlier than the start in UTC

Check full dates, swapped events, incorrect offsets, device configuration and import changes. Preserve the contradiction. Do not take the absolute value, add 24 hours automatically or clamp the result to zero.

A recorded local time falls in a skipped hour

Verify the site's actual transition rule for that date and inspect the source log. A numeric timestamp can be syntactically readable while being inconsistent with the named site's clock rules. Obtain evidence before changing the event.

The site does not change clocks, or the employee moves between zones

Do not apply a one-hour adjustment merely because another site changes clocks. Use the actual date and offset at each endpoint, and confirm which recording zone the source uses. The same method can reconcile events in different zones.

The system already stores UTC

Use the original UTC timestamps to check event order and elapsed duration. Preserve display-zone settings as context, then check whether the report/export converted the times a second time. A display problem does not automatically require a punch correction.

Methodology and limits

This is a per-punch-pair review worksheet, not a DST calendar, timestamp validator or payroll calculator. Example durations use exact minute arithmetic with no rounding. To express verified minutes as decimal hours, divide by 60; preserve the original minute value and apply only your documented rounding policy when appropriate.

The evidence routes, packet checklist and correction-handoff format are TimeTrex editorial review conventions, not official legal requirements. No good/bad duration threshold is assumed. Missing values remain unknown. Historical offset changes, leap-second records, ambiguous source conversions and unusual pay rules need qualified review.

Source references were inspected November 10, 2026. RFC 3339 is a July 2002 timestamp specification, with later updates noted on its publisher's page; it is not a source of wage law. The DOL example concerns U.S. FLSA circumstances and does not establish every jurisdiction's rules. Verify the location's current rules for the event date before relying on a clock-change assumption.

For the wider overnight workflow, read Overnight Shift Time Tracking: Midnight & Payroll Rules. Use this worksheet for the evidence packet, then complete your organization's approval and report-reconciliation process.

Disclaimer: This worksheet supports timestamp-evidence review and does not determine payable time, overtime, legal compliance or the correct historical clock-change rule for a location. Examples are illustrative; review source records, actual work and applicable rules. Verify all inputs, results and assumptions against appropriate records and obtain qualified advice before relying on them. To the fullest extent permitted by applicable law, this resource is provided “as is” without warranties of accuracy, completeness or fitness for a particular purpose, and TimeTrex and its affiliates disclaim liability for losses, damages, costs or claims arising from its use, inability to use, or reliance on it, including errors or omissions. Nothing in this disclaimer excludes or limits liability or rights that cannot lawfully be excluded or limited.

Found our DST Timesheet Review Worksheet useful? Bookmark and share it.

Facebook
X
LinkedIn
Email
WhatsApp
Print
Clock with a backward arrow beside time-record cards and a magnifying glass reviewing repeated times.

Disclaimer: The content provided on this webpage is for informational purposes only and is not intended to be a substitute for professional advice. While we strive to ensure the accuracy and timeliness of the information presented here, the details may change over time or vary in different jurisdictions. Therefore, we do not guarantee the completeness, reliability, or absolute accuracy of this information. The information on this page should not be used as a basis for making legal, financial, or any other key decisions. We strongly advise consulting with a qualified professional or expert in the relevant field for specific advice, guidance, or services. By using this webpage, you acknowledge that the information is offered “as is” and that we are not liable for any errors, omissions, or inaccuracies in the content, nor for any actions taken based on the information provided. We shall not be held liable for any direct, indirect, incidental, consequential, or punitive damages arising out of your access to, use of, or reliance on any content on this page.

Trusted By

Trusted by 3.4M+ Employees: 23 Years of Service Across Startups to Fortune 500 Enterprises

Join our ever-growing community of satisfied customers today and experience the unparalleled benefits of TimeTrex.

Logo for H&R Block
Hilton Hotels and Resorts logo
HP computers logo
Oracle logo black and white
PWC brand logo
Texas A&M University logo
Mcdonald's brand logo
New York Stock Exchange Logo black and white
Walmart brand logo
London Drugs logo black and white

Strength In Numbers

Join The Companies Already Benefiting From TimeTrex

Users
0
Companies
0
Years
0

Time To Clock-In

Start your 30-day free trial!

Experience the Ultimate Workforce Solution and Revolutionize Your Business Today

TimeTrex Mobile App Hand