Google Sheets Weekly Timesheet Template: Setup Tips

Yes. You can make a weekly timesheet template in Google Sheets by creating a table for each day, entering start and end times and unpaid breaks, then using a formula to calculate daily hours. A simple layout works for one person or a small team; the key is to enter time consistently, check the calculations, and share the sheet with suitable access permissions.

What a weekly timesheet should include

A useful timesheet records enough detail to explain how a weekly total was calculated without making everyday entry cumbersome. For a basic employee or personal tracker, use one row per workday and include the date, start time, end time, unpaid break, and total hours. Add a name or employee ID if the sheet will track more than one person, and include a notes column for items such as a shift change or a correction that needs approval.

Week beginning: A clearly labeled date identifies which week the entries cover.
Employee: A name or ID helps identify entries when the file is shared or combined with other records.
Daily entries: Date, start, end, and break fields make the calculation traceable.
Hours and notes: A calculated daily total and a short explanation field help with review.
Weekly total: A summary makes it easy to see the total for the period at a glance.

For example, a seven-row table could use columns A through F for Date, Start, End, Unpaid break (hours), Total hours, and Notes. Keep the break unit explicit: entering 0.5 means half an hour, not a time formatted as 0:30. Clear labels prevent one of the most common spreadsheet mistakes—mixing decimal hours and clock-time values.

Build the template in Google Sheets

In Google Sheets in a web browser, create a blank spreadsheet and set up the headings in the first row. Put a week-start date above the table, then fill the date column with the seven dates you intend to track. You can type each date directly, or enter the first date and use the fill handle to continue the sequence. If the week begins on Monday, the first entry should be that Monday; if your workplace uses a different week boundary, follow that convention consistently.

Enter the headings and add seven daily rows beneath them.
Format the date column using Format > Number > Date, and format the Start and End columns using Format > Number > Time.
Choose whether breaks will be entered as decimal hours, such as 0.5, or as durations. The formula below assumes decimal hours.
Add the daily-hours formula to the first Total hours row, then copy it down through the remaining days.
Add a weekly total below the daily results and leave a notes or approval area if someone else reviews the record.

Google Sheets may show templates in its template gallery, but a suitable weekly timesheet may not be available in every account or locale. A blank sheet is easy to adapt and makes it straightforward to inspect the formulas. If you start from a downloaded template, check its units and formulas before relying on its totals.

Calculate daily hours and the weekly total

Assume the headings are in row 1, with Start in B, End in C, unpaid break hours in D, and Total hours in E. In E2, use this formula and copy it down to E8:

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

The formula leaves the result blank until both time fields are filled in. MOD handles a shift that crosses midnight: for a 10:00 p.m. start and a 6:00 a.m. end, the elapsed time is eight hours before subtracting any break. For a 9:00 a.m. to 5:30 p.m. shift with 0.5 entered in D2, it returns 8. The calculation treats the break as a number of hours, so enter 1 for a one-hour break and 0.25 for 15 minutes.

Format the Total hours column as a number rather than a time: select the cells and choose Format > Number > Number. With daily results in E2:E8, place the weekly total in E9 using:

=SUM(E2:E8)

This adds the seven daily decimal-hour results. If the employee worked 8 hours on five days and did not work on the other two, the total is 40. Keep the total cell outside the range being summed so the formula does not include itself. If your Google Sheets locale uses different formula separators, the displayed formula may need the separator used by that locale.

Make the sheet easier to enter and review

Formatting is not just decoration; it helps people spot missing entries and read the results consistently. Freeze the heading row with View > Freeze if you expect the table to grow, and use bold headings or a background color to distinguish labels from inputs. Avoid applying a time format to decimal-hour totals: a value of 8 can otherwise be displayed as a date or a clock time, which can make a correct calculation look wrong.

For a reusable template, keep the input cells visually distinct from calculated cells. For instance, use a light fill for the date, time, break, and notes fields, and a different fill for formula results. Add a short instruction above the table saying whether breaks are decimal hours. If the same file will be copied every week, make a clean master tab and duplicate it for a new period rather than overwriting a record that still needs review.

Conditional formatting can highlight incomplete rows. In Sheets, select the relevant cells and use Format > Conditional formatting to create a rule. Be cautious about complex rules: a color cue can help identify a missing end time, but it does not validate whether a shift or break is appropriate. Review the actual entries before approving a total.

Adapt it for overtime, leave, and multiple people

A weekly total is an arithmetic sum, not an automatic decision about overtime, paid leave, or payroll. Rules for those categories depend on the employer’s policies and the applicable requirements, so do not assume that a particular weekly threshold or formula determines what someone is owed. If the sheet needs to separate regular time and overtime, add clearly labeled columns and use the correct rules supplied by the organization responsible for payroll.

For vacation, sick time, or other non-worked hours, decide whether those belong in the same weekly total or in separate categories. Keeping them separate usually makes the record easier to understand: a reader can distinguish time worked from paid leave rather than treating both as hours on a shift. Add a category or notes field if entries need that distinction, and make the totals reflect the organization’s reporting process.

For several employees, either use a separate tab for each person or use one table with an Employee column and one row per employee per date. Separate tabs can be simpler for individual review, while one combined table is more convenient for filtering and summarizing. Whichever design you choose, protect against accidentally summing every employee’s hours into a single person’s total. Give each weekly total a defined range or create a summary for each employee rather than relying on an ambiguous grand total.

Common timesheet problems and how to avoid them

Times entered as text: If a time is not recognized as a time value, subtraction may fail. Apply a time format and re-enter the value consistently, such as 9:00 AM or 17:00 according to the sheet’s locale.
Breaks use the wrong unit: The example formula expects decimal hours. Entering 0:30 as a duration in a cell that the formula treats as decimal hours will not mean 0.5 hours.
Totals display strangely: Format calculated hours as numbers. Clock-time formatting is intended for times of day or durations, not necessarily decimal-hour totals.
Overnight shifts look negative: A simple end-minus-start formula can produce a negative result across midnight. The MOD function in the example handles a single overnight span.
Blank rows show unwanted values: The IF test keeps a daily result blank until both start and end are entered. If you change the layout, adjust the cell references as well.
Manual edits replace formulas: Keep formula cells visually distinct and check that copied rows still refer to the matching row’s inputs.

Also decide how to handle multiple shifts in one day. A single start and end pair cannot accurately represent a split shift with a long gap unless that gap is treated correctly as unpaid time. For two separate work periods, add a second start/end pair or use two rows for the date, then make sure the weekly calculation includes both. The best layout is the one that represents the actual entries without hiding assumptions inside a complicated formula.

Sharing, review, and recordkeeping

Google Sheets makes collaboration convenient, but a timesheet can contain personal work information. Use the Share button to give people only the access they need: a reviewer who should not change submitted hours may need viewer or commenter access, while someone entering their own hours needs editing access. Avoid making the file available to anyone with a link unless that level of access is appropriate for the records and your organization’s practices.

Agree on who enters, checks, and approves the hours, and whether the original sheet or a weekly copy is the record to retain. A brief note for corrections can explain why an entry changed, but a note is not the same as a formal audit trail. Google Sheets has version history, which can help users review earlier changes, but organizational retention and approval requirements should be checked separately. Do not treat a spreadsheet total as proof that a time record has been authorized.

Google Sheets compared with Excel and dedicated time apps

Google Sheets is useful when several people need browser-based access, comments, and a lightweight shared tracker. It is also easy to copy a tab or file for each new week. Microsoft Excel can handle similar tables and calculations, but menu names and sharing workflows differ; a Google Sheets formula or instruction should not be assumed to match every Excel setup exactly. Dedicated time-tracking or payroll systems may provide role-based approval flows, reporting, and integrations that a manually maintained sheet does not.

Choose based on the task. A simple personal record or small-team log may be well served by a spreadsheet. If the process requires formal approval, complex shift rules, automatic reminders, integration with payroll, or controlled access across many staff, compare purpose-built systems and your organization’s requirements. The spreadsheet itself does not make a record compliant or guarantee that hours were entered correctly.

Frequently Asked Questions

Does Google Sheets have a weekly timesheet template?

Google Sheets has a template gallery, but the available templates can vary, and a specific weekly timesheet may not appear for every user. You can create the layout in a blank sheet using date, start, end, break, and total columns, then reuse it by copying the tab or file.

How do I calculate total hours in Google Sheets?

Subtract the start time from the end time, account for overnight shifts if needed, and subtract unpaid breaks. The formula in this guide assumes the break is entered as decimal hours and returns a decimal-hour total; format the result as a number.

How do I enter a 30-minute break?

With the example layout, enter 0.5 in the Unpaid break (hours) column. That is half an hour in decimal-hour units. Do not enter 30, which would subtract 30 hours, or enter a duration such as 0:30 unless you change the formula to handle duration values.

Can the timesheet calculate an overnight shift?

Yes. The MOD-based formula shown above handles a shift that ends after midnight, such as 10:00 p.m. to 6:00 a.m. It is intended for a single start/end interval; split shifts need additional entries or a layout that represents each work period.

Can I use this template for payroll or overtime?

You can use a spreadsheet to organize recorded hours, but a basic weekly sum does not determine payroll treatment or overtime rules. Confirm the applicable policies and requirements with the responsible employer, payroll provider, or qualified professional before using a sheet for those decisions.

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.