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.

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

In row 1, enter the following column headings:

A1: Date

B1: Day

D1: Start Time

E1: End Time

F1: Break (hrs)

G1: Total Hours

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:

Step 4: Calculating Total Hours Worked

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

=((E2-D2)*24)-F2

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:

=SUM(G2:G8)