Sample Time Tracking Data
Daily clock-in / clock-out entries with break minutes — for hour totals, overtime and time-format practice.
What is in the file
6 columns, 140 rows by default. The first ten rows are shown below — the download contains exactly this data.
| 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 |
Built in your browser when you click. Nothing is uploaded, no signup, free for commercial use.
About this dataset
Time arithmetic is where spreadsheets embarrass people most often, because a duration over 24 hours needs the [h]:mm format and a subtraction across midnight needs handling. These entries include both cases on purpose, plus break minutes to subtract, so the totals you get are only right if the formatting is right too.
What you can practise with it
- Total hours worked per person per week
- Subtract unpaid break minutes correctly
- Format a total over 24 hours with [h]:mm
- Split regular hours from overtime with IF
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. The file is built in your browser when you click download; nothing is uploaded and no account is involved.
Which formats can I download?
Excel (.xlsx), CSV and JSON. All three contain the same 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. Pick a row count before downloading — the default is 140 rows, which is what the preview on this page is drawn from.