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
| 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
- On Tasks, type each kind of task once.
- In the Log, add a row for each piece of work: the date, the task from the list, and the start and finish time.
- Hours are worked out for you. A finish after midnight counts to the next morning.
- Read Tasks for each task's hours, share and number of entries.
- 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.