Timesheet template with tasks

Log what you did against a list of tasks, with a start and finish time. The sheet works out the hours and shows how your time splits across tasks.

  • No email needed
  • Last reviewed 15 November 2026

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

What it's for

  • Seeing where your time goes across kinds of work, such as research, design and review.
  • Staff and freelancers who need a record by task, not by client.
  • A manager who wants each task's share of the team's time.

What's inside

How to use
Short instructions and the colour key.
Tasks
Your list of tasks, with hours, share of all hours and number of entries for each, and the hours on tasks that are not on the list.
Log
One row per piece of work: date, task from the list, start, finish and notes. Hours are worked out from the times.

Preview

Worked example: two days, four tasks
Date Task Start Finish Hours
1 Mar 2027 Research 09:00 11:30 2.50
1 Mar 2027 Design 11:30 13:00 1.50
1 Mar 2027 Build 14:00 17:30 3.50
2 Mar 2027 Build 09:00 12:00 3.00
2 Mar 2027 Review 13:00 14:00 1.00

All hours: 11.50. Build is 6.50 hours over 2 entries, a 57% share. Research is 2.50 (22%), Design 1.50 (13%) and Review 1.00 (9%).

How to use it

  1. On Tasks, type each kind of task once.
  2. In the Log, add a row for each piece of work: the date, the task from the list, and the start and finish time.
  3. Hours are worked out for you. A finish after midnight counts to the next morning.
  4. Read Tasks for each task's hours, share and number of entries.
  5. Check "Not on the list" is 0, or add the missing task.

The formulas, explained

Hours
=IF(OR(C4="",D4=""),"",MOD(D4-C4,1)*24)

The time between start and finish, even after midnight, times 24 for hours.

Hours for a task
=SUMIFS('Log'!$E$4:$E$303,'Log'!$B$4:$B$303,$A4)

Adds up the Log's hours for that task.

Share of hours
=IF(OR($A4="",N($B$34)=0),"",B4/$B$34)

The task's hours divided by all the hours in the Log.

Every formula uses functions that Excel, Google Sheets and LibreOffice all have. There are no macros or scripts.

Questions

How is this different from the agency timesheet?

The agency timesheet works by client and project with billable hours and rates. This one works by task only, with no clients, rates or billable flag.

Can I add unpaid breaks?

Not in a separate column. Log the work either side of the break as two rows.

How many tasks and rows are there?

30 tasks and 300 log rows; the totals read rows 4 to 303.

Can I see the tasks by day?

The Log is in date order as you type it. To see the tasks for a day, filter the Log by date.

Does it work in Google Sheets?

Yes. Upload it with File > Import in Google Sheets. It only uses functions both programs have (IF, OR, MOD, N, SUM, SUMIFS and COUNTIF). 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.