Weekly Timesheet in Google Sheets: Setup and Tips

Yes. You can make a weekly timesheet in Google Sheets by listing each workday, entering start and end times, subtracting unpaid breaks, and summing the daily hours. A simple sheet can calculate totals automatically, but it is a recordkeeping tool—not, by itself, a time clock, payroll system, or guarantee that entries are accurate.

What a weekly Google Sheets timesheet can do

A basic weekly timesheet records when someone worked and how much time they worked each day. In Google Sheets, a row can represent one day, with columns for the date, start time, end time, unpaid break, and calculated hours. A total at the bottom adds the week’s daily hours. You can make a copy of the template for each employee or week, or organize multiple employees in one file if access and privacy are managed carefully.

The appeal is flexibility: you can adjust columns, add notes, share the sheet with a supervisor, and see calculations update as entries change. A template may suit a small team, a freelancer tracking billable time, or a person keeping a personal work log. It is less suitable when you need a reliable clock-in system, automated approvals, complex shift rules, or a direct and controlled payroll workflow.

One useful distinction: a spreadsheet calculates from the information people enter. It does not independently verify that an employee started or finished work at the recorded time. If that matters, consider a dedicated time-tracking tool rather than treating a shared spreadsheet as proof of attendance.

Set up the weekly layout

In Google Sheets in a web browser, create a blank spreadsheet and put a clear title and the week’s date range near the top. Make a header row with fields such as Date, Start, End, Break (minutes), Hours, and Notes. Put one workday on each row. For a Monday-to-Friday schedule, five rows are often enough; add rows for weekend shifts, split shifts, or multiple work periods as needed.

Keep the data structure consistent. Enter actual dates in the Date column, actual time values in Start and End, and a number of minutes in Break. For example, enter 30 for a half-hour unpaid break—not 0:30—if the formula below is used. Notes can explain an unusual shift or correction, but avoid putting sensitive personal details in a shared sheet.

Use one row per shift or work period if a person has more than one shift in a day.
Label the time zone if workers and reviewers are in different locations.
Include employee name or ID when a file contains more than one person’s records.
Keep the week’s date range visible so a copied sheet is not mistaken for another pay period.

For an especially simple setup, make a separate tab for each week and keep the same column order in every tab. A single tab with a new section for every week can work too, but it is easier to sort or summarize records when each row has a date and each column has one consistent meaning.

Calculate daily hours and the weekly total

Google Sheets stores time-of-day entries as parts of a day. The calculation therefore needs to convert the difference between the end and start times into hours. With start times in B2, end times in C2, and unpaid break minutes in D2, enter this in E2:

=IF(OR(B2="",C2=""),"",MOD(C2-B2,1)*24-D2/60)

The formula leaves the result blank until both time entries are present. MOD allows a shift that crosses midnight to calculate across the day boundary. For example, a shift from 9:00 AM to 5:30 PM with 30 unpaid break minutes returns 8 hours: 8.5 hours elapsed minus 0.5 hours of break. The break value must be a number of minutes for this formula to work as intended.

Copy the formula down the Hours column for the other daily rows. In Sheets, use the small square at the lower-right corner of the selected cell to fill down, or copy and paste the formula into the remaining cells. Relative references adjust by row. Format Hours as a number, such as two decimal places, if you want results like 7.75. Do not format decimal-hour results as clock times: 7.75 hours means 7 hours and 45 minutes, not 7:75.

With daily hours in E2:E6, put the weekly total in E7 using:

=SUM(E2:E6)

If the five daily entries are 8, 8, 7.5, 8, and 8.5, the result is 40 hours. If your schedule uses more rows, change the range to include them. Keep the total separate from the daily values so a reviewer can see both the calculation and the sum. If a worker has multiple shifts in one day, sum the shift rows for the week rather than trying to squeeze separate start and end pairs into a single cell.

Format entries and reduce mistakes

Apply time formatting to the Start and End columns so entries display consistently. Select the relevant cells and choose Format > Number > Time. Format the Date column with a date display using Format > Number, then choose an appropriate date format. Use a number format for calculated hours. Consistent display helps people spot a value that was accidentally entered as text or in the wrong column.

For a clearer sheet, freeze the header row with View > Freeze, and consider adding a filter using Data > Create a filter if a tab contains many rows. Conditional formatting can highlight missing or unusually long entries: select the cells and choose Format > Conditional formatting. Keep rules simple and explain what a highlighted value means; a color is a prompt to review, not proof that a time entry is wrong.

Data validation can help standardize entries, but it does not replace review. Use it for predictable fields such as an employee name or a status label. For time cells, test the rule with representative entries before distributing the template, especially if shifts can cross midnight. Protect formula cells from accidental edits when appropriate, while leaving input cells editable. In Sheets, access and protected-range controls are available through the Data menu, but protection should not be confused with privacy: people with sufficient file permissions may still be able to view information.

Review, share, and approve the sheet

Google Sheets makes it possible for multiple people to access a file, but decide who should edit it before sharing. Use the Share button to invite specific people and choose an appropriate role, such as Viewer, Commenter, or Editor. An employee may need edit access to enter time, while a reviewer may only need to comment or inspect the completed record. Avoid setting broad link access when the sheet includes personal or payroll-related information.

A workable process is to have workers enter their own time, check that the week and employee details are correct, and submit the sheet for review by an agreed deadline. A supervisor can compare unusual entries with schedules or other records, ask for corrections, and mark a review status. If you use an approval column, define what each status means—for example, Draft, Submitted, and Approved—and who is authorized to change it.

Version history can help identify changes and restore earlier content, but it is not a substitute for a clear correction process. Agree on how edits after approval are handled and retain records according to the organization’s own requirements. Because rules for work-time records and pay vary by location and situation, use the sheet only within applicable workplace procedures and have a qualified professional confirm requirements when necessary.

Know the limits of spreadsheet calculations

Several common situations need more than a basic daily-hours formula. A formula can calculate elapsed time, but it cannot decide whether a break is legally required, whether a break is paid, or which hours qualify for overtime. Those depend on the applicable rules, employment terms, and company policy. Do not assume that a spreadsheet’s weekly total automatically equals payable time or determines overtime correctly.

Likewise, entries can be incomplete, mistyped, duplicated, or changed. A shift crossing midnight may calculate correctly with MOD, but a blank break cell, a break longer than the shift, or an accidental text entry can still produce an unhelpful result. Test a copy of the template with typical cases before using it for real records. Add a review step for blank cells, negative or implausible totals, and shifts that span midnight.

Sheets also depends on the file being available to the people who need it and on suitable access settings. A dedicated app may provide clock-in controls, reminders, audit features, location options, or payroll integrations that a hand-built spreadsheet does not. Those features are not automatically necessary for every small project, but they matter when accountability, scale, or regulatory obligations increase.

Google Sheets compared with Excel and time-tracking apps

Google Sheets is convenient when people need a browser-based shared document and a straightforward, editable layout. It can be a good fit for a small group with predictable schedules and a person responsible for checking entries. Its formulas and basic formatting are familiar spreadsheet tools, though menus and some behavior differ from Microsoft Excel. Excel’s desktop app has its own interface and capabilities; instructions for Excel should not be assumed to match the Google Sheets menus described here.

A time-tracking app is generally a better comparison when staff need to clock in and out, submit timesheets through a defined approval flow, track projects, or send approved hours to payroll. Such products may charge fees and have different data, integration, and access policies, so assess the particular service rather than assuming every app offers the same safeguards.

Google Sheets can be used without a separate timesheet purchase by people who have access to the service. Organizations may use Google Workspace plans, whose pricing and included features can change. A template found online may be free or paid, but check its source, formulas, permissions, and any requested access before copying it. The choice is not simply free versus paid: account administration, review time, error risk, and the cost of correcting records also matter.

Frequently Asked Questions

Does Google Sheets have a weekly timesheet template?
Google Sheets users can look for templates through the template gallery or make their own layout in a blank spreadsheet. Available gallery options can vary. Before using a template, inspect its formulas and sharing settings instead of assuming every total or rule is correct for your schedule.

How do I calculate hours worked in Google Sheets?
Enter start and end times as time values, subtract unpaid break time, and convert the elapsed fraction of a day into hours. The formula in this guide assumes break time is entered as minutes. Try it with a known shift and confirm the output before copying it throughout a timesheet.

Can Google Sheets calculate an overnight shift?
Yes. The MOD-based daily formula shown above handles an end time that is earlier than the start time by treating it as the following day. Record the correct work date and check unusual or multi-day shifts separately, because a basic one-row calculation may not describe every scheduling situation.

Can a Google Sheets timesheet calculate overtime?
It can compare totals with a threshold if you design formulas for that purpose, but a threshold alone may not reflect the rules that apply to a worker. Overtime treatment can depend on jurisdiction, workweek definition, and other circumstances. Confirm the correct method before relying on a spreadsheet for payroll.

Is a Google Sheets timesheet suitable for payroll?
It may provide hours for a simple process if entries are checked and the organization’s procedures allow it. It does not automatically verify attendance, apply every pay rule, or transmit accurate payroll data. For larger teams or higher-stakes time records, consider a dedicated system and qualified guidance.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.