Short answer
A timesheet template is a table with one row per day or task and columns for the date, start time, end time, unpaid break and total hours. Copy one of the templates below into Excel or Google Sheets, add the formula for hours worked, and total the column at the end of the week or pay period.
Astrolinks sorts your day by client without a timer and turns the hours into client updates and invoices. Get it free →
Most free timesheet templates online are a download button and a sign-up form. This page gives you the tables themselves, ready to copy into Excel or Google Sheets, plus the formulas that do the math. There are five: a weekly timesheet, a biweekly timesheet, a freelancer timesheet per client, a night shift timesheet for work that crosses midnight, and a monthly summary.
Pick the one that matches how you get paid, copy it, and you're done.
What is a timesheet template?
A timesheet template is a ready-made table for recording the hours someone worked. Each row is a day or a task. The columns hold the date, when work started, when it ended, unpaid breaks, and the total. At the end of the week or pay period, the totals feed payroll or an invoice.
Employees use timesheets to get paid correctly. Freelancers and virtual assistants use them to bill clients and to show what the hours were spent on. Managers use them to approve pay and to see where time goes on a project.
What should a timesheet include?
Every timesheet needs these fields:
- Name of the person working
- Pay period (the week, two weeks or month it covers)
- Date of each day worked
- Start time and end time
- Unpaid break in minutes
- Total hours for the day
- Total for the period, with overtime split out if it applies
- Approval: a signature, initials or an approved date
Freelancers add three more: client, task and billable (yes or no). If you bill different rates, add rate and amount.
Write the task the way your client would describe it. "Updated 14 product listings" is a line nobody questions. "Admin" is a line people ask about.
Template 1: Weekly timesheet
Use this when you're paid or bill every week. Copy the table into row 1 of a blank sheet so the formulas below line up.
| Day | Date | Start | End | Break (min) | Hours | Notes |
|---|---|---|---|---|---|---|
| Monday | Nov 9 | 9:00 | 17:30 | 30 | 8.00 | |
| Tuesday | Nov 10 | 8:45 | 17:15 | 30 | 8.00 | |
| Wednesday | Nov 11 | 9:00 | 18:15 | 45 | 8.50 | Client deadline |
| Thursday | Nov 12 | 9:00 | 17:30 | 30 | 8.00 | |
| Friday | Nov 13 | 9:00 | 16:00 | 30 | 6.50 | Left early |
| Saturday | 0.00 | |||||
| Sunday | 0.00 | |||||
| Total | 39.00 |
Approved by: ____________ Date: ________
The example adds up to 39 hours. Check it yourself with the formulas in the next section; it's a good way to make sure your sheet works before you trust it.
How do you calculate hours on a timesheet?
Subtract the start time from the end time, then take off unpaid breaks. Monday above is 9:00 to 17:30, which is 8.5 hours, minus a 30-minute break, which leaves 8.0 hours.
In Excel or Google Sheets, with Start in column C, End in column D and Break (in minutes) in column E, put this in F2 and copy it down:
=IF(D2="","",MOD(D2-C2,1)*24-E2/60)
What each part does:
- D2-C2 is the time between start and end. Spreadsheets store times as fractions of a day.
- MOD(...,1) fixes shifts that cross midnight. Without it, 21:00 to 6:00 gives a negative number.
- *24 turns the fraction of a day into hours.
- E2/60 turns break minutes into hours.
- IF(D2="","",...) leaves the cell blank on days you didn't work.
For the weekly total, use =SUM(F2:F8). If you want overtime on its own line, use =MAX(0,F9-40) for hours over 40, and =MIN(F9,40) for regular hours.
Two settings matter. Format columns C and D as Time, and type times as 9:00 or 17:30. Format column F as a Number with two decimals, not as Time, or the totals show as clock times.
Minutes to decimal hours
Payroll and invoices use decimal hours. To convert, divide minutes by 60. The common ones:
| Minutes | Decimal hours |
|---|---|
| 6 | 0.10 |
| 10 | 0.17 |
| 15 | 0.25 |
| 20 | 0.33 |
| 30 | 0.50 |
| 40 | 0.67 |
| 45 | 0.75 |
| 50 | 0.83 |
So 7 hours 45 minutes is 7.75 hours, not 7.45. That mix-up is the most common timesheet mistake there is, and it costs the worker 18 minutes every time.
Template 2: Biweekly timesheet
A biweekly timesheet covers 14 days, which gives 26 pay periods a year. Don't confuse it with semimonthly, which is twice a month (for example the 15th and the last day) and gives 24 periods.
The layout is the weekly template twice, with a subtotal under each week:
| Week | Day | Date | Start | End | Break (min) | Hours |
|---|---|---|---|---|---|---|
| 1 | Monday | Nov 9 | 9:00 | 17:30 | 30 | 8.00 |
| 1 | ... | ... | ... | ... | ... | ... |
| 1 | Week 1 total | 39.00 | ||||
| 2 | Monday | Nov 16 | 9:00 | 17:30 | 30 | 8.00 |
| 2 | ... | ... | ... | ... | ... | ... |
| 2 | Week 2 total | 40.00 | ||||
| Period total | 79.00 |
Keep a subtotal for each week, even though pay comes every two weeks. In the US, overtime under the Fair Labor Standards Act is worked out per workweek, not per pay period. Two weeks of 45 and 35 hours is 80 hours, and 5 of them are overtime, even though the average is 40. If you run payroll, check the rules where your people work.
Template 3: Freelancer timesheet per client
Freelancers don't need clock in and clock out. They need to know which client each piece of work was for, and whether it's billable. One row per task:
| Date | Client | Project | Task | Start | End | Hours | Billable |
|---|---|---|---|---|---|---|---|
| Nov 10 | Halcyon Dental | Billing | Reconciled October invoices | 9:00 | 9:45 | 0.75 | Yes |
| Nov 10 | Brightline Co. | Social | Scheduled 12 posts for next week | 9:45 | 10:45 | 1.00 | Yes |
| Nov 10 | Brightline Co. | Social | Call about the December campaign | 11:00 | 11:20 | 0.33 | Yes |
| Nov 10 | Own business | Admin | Sent last week's invoices | 11:30 | 11:50 | 0.33 | No |
| Nov 10 | Halcyon Dental | Billing | Answered patient billing questions | 13:00 | 14:30 | 1.50 | Yes |
The clients are made up. At the end of the week, a pivot table or SUMIFS gives you hours per client. In Google Sheets, =SUMIFS(G:G,B:B,"Halcyon Dental",H:H,"Yes") totals Halcyon's billable hours.
Short rows are fine. A 10-minute call deserves its own line. Our guide on how to track billable hours covers what counts as billable and how to round.

Template 4: Night shift timesheet
Many virtual assistants in Asia work US hours, so the shift starts one day and ends the next. A timesheet that can't handle midnight will show a negative number, or the wrong date.
Two rules make it work:
- Date the shift by the day it started. A shift from 21:00 on Monday to 6:00 on Tuesday goes on Monday's row.
- Use the MOD formula from earlier. It treats 21:00 to 6:00 as 9 hours, not minus 15.
| Shift date | Client | Start | End | Break (min) | Hours | Client's time zone |
|---|---|---|---|---|---|---|
| Mon Nov 9 | Northwind Realty | 21:00 | 1:00 | 0 | 4.00 | US Eastern |
| Mon Nov 9 | Halcyon Dental | 1:30 | 6:00 | 0 | 4.50 | US Pacific |
| Tue Nov 10 | Northwind Realty | 21:00 | 2:00 | 15 | 4.75 | US Eastern |
Keep the times in your own time zone on the timesheet, and write the client's zone in its own column. When a client asks "what did you do Tuesday morning?", you can convert one shift rather than a whole sheet. Our guide for night shift VAs covers the time zone math and shift handovers.
Template 5: Monthly timesheet summary
A monthly summary is the page a client or accountant actually reads, and the numbers you copy into an invoice or the free invoice generator. It doesn't repeat every task. It rolls them up:
| Client | Billable hours | Non-billable hours | Rate | Amount | Invoiced |
|---|---|---|---|---|---|
| Halcyon Dental | 42.50 | 1.25 | $40 | $1,700.00 | Yes, Nov 30 |
| Brightline Co. | 28.75 | 0.50 | $50 | $1,437.50 | Yes, Nov 30 |
| Northwind Realty | 36.00 | 2.00 | $45 | $1,620.00 | No |
| Total | 107.25 | 3.75 | $4,757.50 |
Build it from the per-client timesheet with SUMIFS, so you never type a total by hand. The Invoiced column stops two of the most expensive mistakes in freelancing: billing twice and not billing at all. When it's time to send the bill, our guide on how to invoice hourly clients walks through the invoice itself.
Which timesheet template should you use?
- Paid by the hour as an employee, weekly: Template 1.
- Paid every two weeks: Template 2, with weekly subtotals.
- Freelancer or VA billing several clients: Template 3 daily, Template 5 monthly.
- Working a shift that crosses midnight: Template 4.
If you work for more than one client, Template 3 is the one that saves arguments, because every hour has a client and a task next to it. Our guide on tracking time across multiple clients has a routine that keeps it tidy.
Common timesheet mistakes
- Writing 7.45 for 7 hours 45 minutes. It's 7.75. Use the conversion table.
- Filling it in on Friday from memory. People forget the small things first: the quick call, the five replies, the fix after hours. Fill it in daily, or at least review it daily.
- No break column. Then nobody can tell whether 9:00 to 17:30 means 8.5 hours or 8.
- Totals typed by hand. Use SUM. Hand totals are where most errors hide.
- Vague tasks. "Work" and "admin" get questioned. Outcomes don't.
- No approval line. If a timesheet feeds pay or an invoice, someone should sign off on it.
How long to keep them depends on where you are. In the US, the Department of Labor asks employers to keep the records that hours are calculated from, like timecards, for at least two years, and payroll records for three. Freelancers should keep theirs at least as long as their invoices.
How Astrolinks fills in the timesheet for you
The hardest part of any timesheet is remembering. Astrolinks keeps a private log of your workday on your own computer, sorts the time by client, and shows it on Hours. No screenshots, no keystrokes, and nothing leaves your computer unless you send it. At the end of the day you check the hours, and Save as CSV gives you rows you can paste straight into any template above. The same day also becomes each client's end-of-day report.
The templates on this page work fine on their own. If you keep forgetting to fill them in, that's the gap Astrolinks closes.
