In this article:

Free Timesheet Template for Google Sheets (2024 Update)

May 8, 2024

Free Timesheet Template in Google Sheets

Feel free to make a copy of this timesheet template in Google Sheets. Don't request for permission to edit, simply go to File > Make a copy.

How to Create a Timesheet in Google Sheets

Below we have outlined the steps on how to create a timesheet in Google Sheets. We'll guide you through creating a basic weekly timesheet. 

Step 1: Setting Up Your Google Sheet

Open a blank spreadsheet and enter a name, e.g., "Weekly Timesheet."

Step 2: Designing Your Timesheet

In row 1, enter the following column headings:

A1: Date

B1: Day

C1: Project/Task

D1: Start Time

E1: End Time

F1: Break (hrs)

G1: Total Hours

Use the toolbar to make your headings bold and adjust column width to fit your content.

timesheet template google sheets

Step 3: Inputting Data

Start from A2 and B2 to enter your dates and days, respectively. For example, enter "03/23/2024" in A2 and "Monday" in B2. Drag the fill handle (small square at the bottom right of the cell) down to auto-fill dates and days.

In C2, enter a project/task name. For start and end times (D2 and E2), use a 24-hour or AM/PM format. For breaks, enter the number of hours taken as a break in F2.

Below we have our sample data:

google sheets timesheet template

Step 4: Calculating Total Hours Worked

In G2, enter the following formula to calculate total hours worked minus break time:


Note: Google Sheets stores times as fractions of a day, so 1 hour = 1/24.

Drag the fill handle in G2 down to apply the formula to other rows.

Step 5: Summing Up the Week

Skip a row after your last entry and label it "Total" in column A.

In the corresponding "Total Hours" cell under column G, sum up all the hours for the week:


Adjust the cell range according to your data.

You can use the toolbar (Fill color) to change the background color for emphasis.

sample timesheet google sheets

We hope that this article has helped you and given you a better understanding of how to create a timesheet in Google Sheets. If you enjoyed this article, you might also want to check out our Gantt chart template and debt payoff template in Google Sheets.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->