Employee Timesheet Template: Editable Work Intervals and a Checked Example

Understand what the files record

The U.S. Department of Labor’s work-hours recordkeeper instructions describe recording start and stop times and adding daily and weekly totals. The original files here use a simpler practice layout with two worked intervals per day, not a claim of statutory completeness.

The blank file can be opened in a spreadsheet editor. The filled file contains only fictional names and a five-day example. Times use a 24-hour clock on the same day. The gap between intervals is outside the worked intervals in this exercise; the file does not label that gap as legally unpaid or determine which real-world activities must be compensated.

Inspect the complete five-day example

Calculate with minutes before converting to decimals

For one interval, convert the end and start to minutes after midnight and subtract. Friday afternoon ends at 15 × 60 + 30 = 930 and starts at 12 × 60 + 30 = 750. The difference is 180 minutes, or three hours. Add the two intervals before computing the daily decimal.

Do not read 7 hours 30 minutes as 7.30 decimal hours. Thirty minutes is 30 ÷ 60 = 0.5 hours, so the decimal is 7.5. The filled CSV includes supplied arithmetic values, not spreadsheet formulas or automatic payroll calculations; recalculate totals after changing any time.

Keep a correction trail rather than silently replacing a value

Original Friday end entry: 15:00. Corrected entry: 15:30, supported by the fictional worker’s checked record. The correction adds 30 minutes. Friday changes from 330 to 360 minutes, and the week changes from 2,100 to 2,130 minutes, or from 35 to 35.5 hours.

The separate correction CSV records the field, old value, new value, reason and reviewer. In actual use, follow the organization’s authorized correction and approval process and retain required supporting records. Do not use a sample reviewer name as if a real person had approved your entry.

Adapt the blank sheet to the actual recording process

Replace fictional identifiers and record actual intervals using the organization’s rules. If a shift crosses midnight, uses more intervals or includes time whose classification is uncertain, this same-day two-interval example is insufficient: use the approved system and ask the responsible payroll or HR contact.

For a final check, total minutes independently, convert the week once and compare it with the sum of daily decimal values. A matching total checks arithmetic only. It does not verify the underlying hours or establish that the template contains every field a particular jurisdiction or employer requires.