Daily timesheet template with a task log

One day on one page: when you started, took a break and finished, and what you did in between. Hours worked and the time not yet logged to a task are worked out for you.

  • No email needed
  • Last reviewed 15 November 2026

For Google Sheets, download the .xlsx and open it with File > Import.

More about each format: Excel, PDF, Word

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

Worked example: one day, 9:00 to 17:30 with a 30 minute unpaid break
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

  1. Type the employee and the date, then the time you started and finished and any unpaid break in minutes.
  2. Hours worked appears under them. A shift that finishes after midnight is counted to the next morning.
  3. Log each task with the time it started and ended. Leave a lunch break out of the tasks.
  4. Check "Hours not logged to a task" is 0.00, or add the missing task.
  5. 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-B28

Hours 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.

Track this in Jasper

Log hours by client and project, approve timesheets and follow retainer hours, next to your team chat.

Want this by email?

Entirely optional. Everything on this page works without an email address.

Sent by Shakewell Agency Pty Ltd, Sydney, Australia. Every email has an unsubscribe link. Privacy policy.