How To Make A Timesheet In Google Sheets

In this tutorial, you will learn how to make a timesheet in Google Sheets.

Whether you’re working as a freelancer or managing a small business, having an affordable and flexible option for tracking time is important to ensure timely payment and proper records. This tutorial will show you how to set up a basic timesheet template in Google Sheets that can be copied and used repeatedly for all your employees or clients

Timesheet Setup

Here’s how to set up a timesheet template that can be used again and again

Step 1

To properly log time, you’ll need to track Date, Start Time, End Time and Breaks for each day worked, then calculate the Work Hours. Add these column headers to the spreadsheet

Step 2

Next, we’ll apply the appropriate number formatting to these columns. To format the Date column as a date, select the entire column by clicking on the column letter then open the Format menu, hover over Number and choose Date

Step 3

Format the Start and End Times columns as Time using the same method

Step 4

Format the Breaks and Work Hours columns as Duration

Step 5

Add the timesheet start date under the Date header, then in the cell below type “=A2 + 1” to put the next date in the cell below

Step 6

Drag the formula down to cover as many dates as you want. For example, if your company pay period is a month, you might want to drag down the dates for the entire month.

Step 7

In the Work Hours column in row 2, type the following formula: “=C2-B2-D2” and drag down for all dates. This formula will calculate the total number of hours worked and subtract any breaks entered in the breaks column

Step 8

To the right of the Work Hours column, add another header for Total Hours and input this formula to sum all hours in the period: “=SUM(E:E)

Step 9

If you need to convert the total to decimal time, the formula to do so is “=G2*24

Step 10

The timesheet is now ready to use.

Using the Timesheet Template

Once the template is set up, it’s time to use it

Step 1

Start by making a copy of the template spreadsheet for each employee by opening the file menu and choosing Make a Copy

Step 2

To update the timesheet date range, simply update the start date stored in cell A2 and the formulas will update all following dates

Step 3

Add new pay periods to the spreadsheet by clicking on down arrow icon on the initial pay period tab and selecting Duplicate from the menu

Step 4

The template copy is now ready to use. Enter start and end dates and the duration of breaks into the appropriate columns. The daily totals and period total will calculate

Summary

Example Spreadsheet: Make a copy of the example spreadsheet

In this tutorial, I covered how to make a timesheet in Google Sheets. Want more? Check out all the Google Sheets Tutorials.