Astrolinks

Free timesheet template: weekly, biweekly and per client

Free timesheet templates to copy into Excel or Google Sheets: weekly, biweekly, per client and night shift, with formulas that add up hours for you.

A man at his desk smiling at the camera, with a keyboard and a monitor in front of him
Photo: sammy-sander on Pixabay

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.

A man writing notes on paper beside his laptop
Photo: startupstockphotos on Pixabay

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:

  1. 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.
  2. 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.

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.

Let the report write itself

Astrolinks keeps a private log of your workday on your Mac and Windows and writes each client’s end-of-day report when you clock out. You check it and send. 7 days of Pro to start, no card.

Questions

What should a timesheet include?

Your name, the pay period, and for each day the date, start time, end time, unpaid break and total hours. Freelancers add the client, the task and whether it is billable. End with the total for the period and a signature or approval line.

How do I calculate hours on a timesheet?

Subtract the start time from the end time, then subtract unpaid breaks. In Excel or Google Sheets, use =MOD(End-Start,1)*24-Break/60 with the break in minutes. MOD keeps shifts that cross midnight correct.

How do I convert minutes to decimal hours?

Divide the minutes by 60. 15 minutes is 0.25 hours, 30 minutes is 0.5, 45 minutes is 0.75, and 20 minutes is 0.33. So 7 hours 45 minutes is 7.75 hours.

What is the difference between a weekly and a biweekly timesheet?

A weekly timesheet covers 7 days and is used when people are paid or billed every week. A biweekly timesheet covers 14 days, which gives 26 pay periods a year. Semimonthly is different: twice a month, 24 periods a year.

Does Google Sheets have a timesheet template?

Not in the default template gallery. Copy one of the tables on this page into a blank sheet, set the time columns to the Time format, and add the formulas shown. It takes about five minutes.

Clock out with the report already written

7 days of Pro to start. No card. Your log stays on your computer.