Free Excel timesheet template

How to use it

1. Download the Excel file (.xlsx), or the CSV file if you use Google Sheets.
2. Type the worker’s name, the Monday the week starts and the approver’s name in the yellow cells at the top. The dates and days fill in for you.
3. For each day, enter the client or project, role and task, then the start and end times (for example 9:00 and 17:30) and any unpaid break in minutes.
4. Mark each line Y if it is billable and enter the hourly rate. Hours, billable hours and the amount calculate themselves.
5. Save a copy for each week, then have the worker and the approver sign at the bottom.

The formulas, explained

• Hours: =ROUND(MOD(End−Start,1)×24 − Break/60, 2). MOD makes a shift that ends after midnight count correctly.
• Amount: hours × rate when the line is marked Y, otherwise 0.
• Billable hours: =SUMIF(Billable,"Y",Hours).
• Dates: each day is the week-start date plus 0 to 6, and the day name comes from TEXT(date,"dddd").

To add more lines, insert rows above the totals; the SUM formulas stretch to include them. Print in landscape to fit one page.

What each column does

Column	What to enter
Date, Day	Filled in from the week-start date. Extra lines at the bottom are for a second entry on the same day.
Client or project, Role, Task	What the time was spent on. Keeping the role lets you bill different rates for different roles.
Start, End, Break (min)	Times like 9:00 and 17:30, and the unpaid break in minutes. Shifts that end after midnight work too.
Hours	Calculated: end minus start, minus the break, rounded to two decimals.
Billable (Y/N), Rate, Amount	Mark Y for billable time and enter the hourly rate; the amount is hours × rate.

Questions