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.
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
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.
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:
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.
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)
Adjust the cell range according to your data.
You can use the toolbar (Fill color) to change the background color for emphasis.
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.
