What it's for
- Staff who fill in a timesheet at the end of each day.
- Showing a manager or client what a day was spent on, task by task.
- Checking that the tasks you logged add up to the hours you worked.
What's inside
- How to use
- Short instructions and the colour key: yellow cells are yours, grey cells calculate.
- Day
- Employee, date, start, finish and unpaid break at the top, then 14 task lines with a start and end time each, and signature lines.
Preview
| Task | Start | End | Hours |
|---|---|---|---|
| Design review | 09:00 | 11:00 | 2.00 |
| Client call | 11:00 | 12:00 | 1.00 |
| Build | 12:30 | 16:30 | 4.00 |
| Admin | 16:30 | 17:30 | 1.00 |
Hours worked: 9:00 to 17:30 is 8.5 hours, less the 30 minute break, so 8.00. The four tasks add up to 8.00 too, so 0.00 hours are not logged to a task.
How to use it
- Type the employee and the date, then the time you started and finished and any unpaid break in minutes.
- Hours worked appears under them. A shift that finishes after midnight is counted to the next morning.
- Log each task with the time it started and ended. Leave a lunch break out of the tasks.
- Check "Hours not logged to a task" is 0.00, or add the missing task.
- Print the sheet, sign it and pass it on.
The formulas, explained
- Hours worked
-
=IF(OR(B5="",B6=""),0,MAX(0,MOD(B6-B5,1)*24-N(B7)/60))MOD(finish − start, 1) is the time between the two, even when the shift ends after midnight. Times 24 turns it into hours, and the unpaid break (minutes ÷ 60) comes off.
- Task hours
-
=IF(OR(B11="",C11=""),0,MAX(0,MOD(C11-B11,1)*24))The same calculation for each task line, without a break.
- Not logged to a task
-
=B27-B28Hours worked at the top minus the hours on the task lines. A negative number means the tasks add up to more than the day.
Every formula uses functions that Excel, Google Sheets and LibreOffice all have. There are no macros or scripts.
Questions
What should a daily timesheet include?
The date, the start and finish time, any unpaid break, the hours worked and who it belongs to. A task log is optional but it shows where the day went. What you must record by law depends on where you are, so check with your regulator.
How is this different from the weekly timesheet?
The weekly timesheet has one row for each day. This one is one day with a line for each task, and it checks the task times add up to the day.
What if I worked past midnight?
Type the finish as the clock time (for example 06:30). The file counts the time to the next morning. A start equal to the finish counts as 0 hours, so split a 24-hour shift over two days.
Is a lunch break counted?
Only if you leave it out of the unpaid break. Type unpaid breaks in minutes at the top, and leave break time out of the task lines.
Does it work in Google Sheets?
Yes. Upload it with File > Import in Google Sheets. It only uses functions both programs have (IF, OR, MAX, MOD, N and SUM). It also opens in LibreOffice.
About this template
Last reviewed 15 November 2026.
Changes: 15 November 2026: first published.
Free to use and change in your own business. Please don't resell the files or publish them as your own. More free templates.