What's in the Excel file
- A Clients sheet and a Projects sheet where you set each project's hourly rate.
- A Time log of 500 ready rows: date, person, client, project, task, hours and Yes or No for billable. The rate fills in from Projects.
- A By week sheet with the same totals for each week from the first week you choose.
- Formulas only, using functions Excel, Google Sheets and LibreOffice all have. There are no macros.
How to use it in Excel
- Download the file. Use the download button on this page to save agency-timesheet.xlsx.
- Open it in Excel. Open the file. If Excel opens it in Protected View, choose Enable Editing so the formulas can calculate.
- List clients and projects. On Clients, type each client once. On Projects, add each project with its client and hourly rate.
- Log the work. In the Time log, add a row for each piece of work. Pick the client and project from the lists, type the hours as decimals (1 hour 30 minutes is 1.5) and choose Yes or No for billable.
- Read the totals. Check Clients, Projects and By week, after typing the first day of your first week on By week.
The formulas inside
- Rate
-
=IF(OR(C4="",D4="",COUNTIFS(match)=0),"",SUMIFS(Projects!$C$4:$C$103,match)/COUNTIFS(match))Looks up the hourly rate for that client and project on the Projects sheet, where match is the client and project columns. If the pair isn't there, the rate stays blank and a billable line turns red.
- Billable value
-
=IF(F4="","",IF(AND(G4="Yes",ISNUMBER(H4)),F4*H4,0))Hours × rate for billable lines, 0 for the rest.
- Billable hours per client
-
=SUMIFS('Time log'!$F$4:$F$503,'Time log'!$C$4:$C$503,$A4,'Time log'!$G$4:$G$503,"Yes")Adds up the billable hours logged against that client.
- Billable %
-
=IF(OR($A4="",N(B4)=0),"",C4/B4)Billable hours ÷ all hours.
- Hours in a week
-
=SUMIFS('Time log'!$F$4:$F$503,'Time log'!$A$4:$A$503,">="&A5,'Time log'!$A$4:$A$503,"<"&A5+7)Adds up hours dated from the week's first day up to, but not including, the next week's.
Every formula uses functions that Excel, Google Sheets and LibreOffice all have. There are no macros or scripts.
What the Excel version doesn't do
- The Time log has 500 rows. For more, copy the last row's formulas down and widen the ranges in the totals, which end at row 503.
- It values billable time at the project rate. It does not invoice, add tax or hold expenses.
- The grey cells calculate, so they are locked. Unprotect the sheet (Review > Unprotect Sheet) to change one; there is no password.
Questions
Does it work in Google Sheets?
Yes. Upload the .xlsx to Google Drive, or use File > Import in Google Sheets. It only uses functions both programs have. We do not offer a "make a copy" link, because that needs a Google account to host the sheet.
Why is a rate blank?
The client and project in that row do not match a row on the Projects sheet. Pick the project from the list for that client. A billable line with no rate turns red.
Is a billable percentage target built in?
No. The file shows each client's billable percentage but does not suggest a target, because a good one depends on the role and how you price work.
Last reviewed 30 October 2026. Free to use and change in your own business. Please don't resell the files or publish them as your own. More free templates.