Sample Time Tracking Data
Same-day clock-in / clock-out values in decimal hours, with break minutes — for duration, hour totals and overtime practice.
What is in the file
6 columns, 140 data rows by default, plus a header row. These are the first ten rows of the default file.
| Entry ID | Employee | Date | Clock In | Clock Out | Break (min) |
|---|---|---|---|---|---|
| ENT-1000 | Oliver | 2026-02-07 | 8.03 | 19.3 | 37 |
| ENT-1001 | Liam | 2026-02-26 | 8.86 | 20.75 | 18 |
| ENT-1002 | Jonas | 2026-03-16 | 6.38 | 15.2 | 89 |
| ENT-1003 | Mia | 2026-01-04 | 7.2 | 16.65 | 71 |
| ENT-1004 | Felix | 2026-02-22 | 8.72 | 18.1 | 21 |
| ENT-1005 | Sofia | 2026-03-13 | 9.55 | 19.55 | 3 |
| ENT-1006 | Adam | 2026-01-01 | 7.06 | 21 | 74 |
| ENT-1007 | Emma | 2026-01-19 | 7.89 | 15.45 | 55 |
| ENT-1008 | Ava | 2026-01-07 | 6.65 | 14.71 | 68 |
| ENT-1009 | Chloe | 2026-01-26 | 7.48 | 16.16 | 49 |
Download 140 rows
6 columns · header included · no signup
Direct files work without JavaScript. Choose another size below.
Built in your browser when you click. Nothing is uploaded, no signup, free for commercial use.
About this dataset
These synthetic same-day entries store clock-in and clock-out as decimal hours, not Excel time values. Subtract the start from the end and divide break minutes by 60 to calculate paid hours. For an hours-and-minutes display, first divide the resulting decimal hours by 24, then apply an elapsed-time format in desktop Excel. The download contains no overnight shifts.
The Excel download stores date columns as numeric Excel dates with a date format. CSV and JSON contain ISO date text; convert those fields to dates during import before using date arithmetic or grouping by month.
File layout and import notes
- Clock In and Clock Out are plain numbers: 7.5 means 07:30, while 8.03 means 8 hours plus 0.03 hour, or 08:01:48. Do not read the decimal digits as minutes.
- Clock In values run from 6 to 10 and Clock Out from 14 to 21. Every generated shift ends later on the same day; these rows do not test subtraction across midnight.
- Break (min) is minutes, so convert it to hours before subtracting it. Date is a separate calendar date and does not change the units in the clock columns.
Subtract breaks without mixing hours and minutes
Use the default 140-row file with headers in row 1, treating the break as unpaid for this exercise. Add Paid hours in G1 and Duration in H1. Fill G2 and H2 down to row 141. Show G as a number with two decimal places. In desktop Excel, format H as [h]:mm:ss to compare the full duration below, or [h]:mm to hide seconds.
G2: paid time in decimal hours
=(E2-D2)-F2/60H2: convert decimal hours to an Excel duration
=G2/24Outside A:H: total paid decimal hours
=SUM(G2:G141)Outside A:H: total duration for [h]:mm:ss
=SUM(G2:G141)/24| Excel row | Entry ID | G: Decimal hours, 2 decimals | H: Duration [h]:mm:ss |
|---|---|---|---|
| 2 | ENT-1000 | 10.65 | 10:39:12 |
| 3 | ENT-1001 | 11.59 | 11:35:24 |
| 4 | ENT-1002 | 7.34 | 7:20:12 |
If columns are cut off, scroll the table sideways.
| Check | Expected |
|---|---|
| Total paid decimal hours, displayed to 2 decimals | 1248.29 |
| Total duration, displayed as [h]:mm:ss | 1248:17:36 |
| Overnight shifts in the source rows | 0 |
If columns are cut off, scroll the table sideways.
- The clock columns are decimal hours: 7.5 is 07:30, and 8.03 is 08:01:48. They are not Excel time serials or hours.minutes values.
- For the first record, 19.30 minus 8.03 minus 37/60 gives 10.6533333333 hours, displayed as 10.65. G2/24 is the Excel duration 10:39:12. Applying a time format directly to G2 uses the wrong units.
- Display rounding does not change the stored value. Sum the unrounded helper values; rounding every shift first can change the total.
- All downloaded shifts end later on the same day. This subtraction does not handle overnight shifts; do not reuse it for an end time earlier than the start without a separate date-aware calculation.
- Use brackets around h for totals over 24 hours. Microsoft documents custom-format steps for desktop Excel and a custom-format authoring limitation in Excel for the web.
- When importing CSV or JSON, keep Clock In and Clock Out (D:E) as decimal numbers and Break (min) (F) as a number; choose dot-decimal parsing if your locale needs it. Do not import D:E as clock-time values. Date (C) is not used in these formulas; convert its ISO text to a date before weekly grouping.
- These checks apply only to the default 140-row file. With another size, update the ranges and recalculate totals. The formulas use English SUM and comma/dot conventions where applicable.
Documentation reviewed .
Microsoft: Add or subtract timeMicrosoft: Convert timesMicrosoft: Format dates or times
What you can practise with it
- Total hours worked per person per week
- Subtract unpaid break minutes correctly
- Convert total decimal hours to an Excel duration and display it with [h]:mm
- Split regular hours from overtime with IF
Try a related exercise
- Count working days between two dates — Date arithmetic that respects weekends — the difference between a calendar and a delivery promise.
Tools that work on this data
Free to use, share and republish — including commercially. Attribution isn't required, but it's what keeps these free to make, and there's one ready to paste below.
Questions
Is this sample time tracking data free to use?
Yes — for practice, teaching, demos and commercial work alike. The rows are generated, so there is no personal data in the file. Attribution is not required; if you would like to credit it, there is a ready-made line at the bottom of this page.
Do I have to sign up or give an email address?
No. Direct links download the default-size files without JavaScript. The row-count control builds other supported sizes in your browser. Your spreadsheet contents are not uploaded and no account is involved.
Which formats can I download?
The original dataset is available as Excel (.xlsx), CSV and JSON. All three contain the same source rows, so you can use the CSV for an import exercise and the .xlsx for a formula exercise.
Can I choose how many rows I get?
Yes. The browser control offers 25, 100, 140, 500 data rows, plus a header. Direct source links contain 140 data rows; the preview shows the first ten of those rows.