Biweekly Timesheet Template for Google Sheets: Setup

Yes—make a biweekly timesheet in Google Sheets with one row for each of 14 days, columns for date, start time, end time, unpaid break, and calculated hours. If start and end times are in B2 and C2 and break hours are in D2, enter =IF(OR(B2="",C2=""),"",MOD(C2-B2,1)*24-IF(D2="",0,D2)) in E2 and fill it down; it handles shifts that cross midnight and returns decimal hours.

What a biweekly timesheet covers

A biweekly pay period is a 14-day period, usually made up of two seven-day workweeks. It is not the same as twice-monthly pay, which generally divides the calendar month into two pay dates and can produce periods of different lengths. A useful sheet records the dates actually worked, rather than assuming every pay period starts on the first or fifteenth of a month.

Google Sheets is useful for this kind of record because it can calculate daily hours, share a copy with a worker or manager, and keep a record of edits. But a template is only a recordkeeping tool. It does not determine which breaks are paid, which time counts as work, or how overtime should be treated. Those rules depend on the employer’s policy and applicable requirements, so confirm them before relying on the sheet for payroll.

Recommended columns and layout

Keep the main entry table simple enough that a person can fill it out consistently. Put a period start date and employee or project details above it, then use one row per calendar day. A practical set of columns is:

Date: the calendar date for the shift.
Start: the time work began.
End: the time work ended.
Unpaid break (hours): the unpaid portion of the shift, entered as a decimal such as 0.5 for 30 minutes.
Hours worked: a formula result, not a manually entered total.
Notes: optional details such as a job code, location, or approved correction.

For example, put headers in A1:F1, with Date in A, Start in B, End in C, Unpaid break (hours) in D, Hours worked in E, and Notes in F. Use rows 2 through 15 for the 14 days. Add a total beneath the table. If people work on multiple projects in one day, use separate shift rows or add a project column; do not combine entries if doing so would hide the time assigned to each project.

Build the 14-day sheet

Open Google Sheets in a browser and create a blank spreadsheet, or open a suitable file from the Sheets template gallery. Give the file a clear name, such as “Timesheet — Employee — Pay Period Ending Date.”
Enter the period start date in a clearly labeled cell, such as B1. Add employee name, manager, or department fields only if they are needed.
Enter the date for each row from the first day through the fourteenth day. You can type the dates directly or enter the first date in A2 and the next date in A3, then select both cells and drag the fill handle down to A15. Check that the resulting dates cover exactly 14 consecutive days.
Add the column headers and the hours formula described below. Copy the formula through all 14 daily rows.
Format the date, time, and total cells so the entries are easy to read, then test a normal shift and an overnight shift before sharing the template.

For regular use, make a fresh copy for each pay period instead of deleting the old entries from the only file. That preserves a separate record and reduces the chance that someone will overwrite a prior period by mistake.

Calculate hours and period totals

With start times in B2:B15, end times in C2:C15, unpaid break hours in D2:D15, and calculated hours in E2:E15, put this formula in E2 and fill it down through E15: =IF(OR(B2="",C2=""),"",MOD(C2-B2,1)*24-IF(D2="",0,D2)). The formula leaves the result blank until both time entries exist. Google Sheets stores times as fractions of a day, so multiplying the time difference by 24 converts it to hours. MOD handles a shift ending after midnight: for a 10:00 p.m. start and 6:00 a.m. end, it treats the elapsed time as eight hours rather than a negative value.

For a concrete check, a shift from 9:00 a.m. to 5:30 p.m. with D2 entered as 0.5 has 8 hours worked: 8.5 elapsed hours minus a half-hour unpaid break. This calculation assumes the break is unpaid and that the start and end entries describe one continuous shift. If someone has multiple work periods separated by a long gap, record separate shifts rather than treating the entire span as work time.

With daily calculated hours in E2:E15 and the total placed in E16, enter =SUM(E2:E15) in E16. For example, if the 14 daily results sum to 72.5, the formula returns 72.5 hours. Label the cell “Period total” so it is not mistaken for a weekly total or an overtime figure.

Format times and prevent entry errors

Select the date cells and use Format > Number > Date. Select the start and end cells and use Format > Number > Time. Set the hours and break columns to a number format with enough decimal places for the precision your organization uses. A value of 0.25 in the break column means 15 minutes; entering “30” to mean 30 minutes would subtract 30 hours, so make the unit explicit in the header and instructions.

Data validation can reduce inconsistent entries. Select the relevant cells and choose Data > Data validation to set rules for dates or numbers where appropriate. For example, you can restrict break entries to nonnegative numbers, but a rule cannot confirm by itself that a break was actually taken or that a submitted time is accurate. Use a short note near the table to explain whether users should enter breaks as decimal hours or as a time duration. Do not mix the two formats.

Freeze the header row using View > Freeze > 1 row if the sheet will be scrolled on a phone or a long screen. If users type directly into a shared file, visually distinguish the input cells from formula cells. Protecting formula cells can help prevent accidental edits; use Data > Protect sheets and ranges and set access carefully. Protection is an editing control, not a substitute for limiting who can view sensitive records.

Overtime, breaks, and payroll context

A single 14-day total is not enough to determine overtime in every workplace. Some rules are based on hours in a defined workweek, and a biweekly pay period contains two workweeks that may need to be reviewed separately. The organization’s workweek start day, treatment of different types of leave, and applicable rules all matter. Avoid labeling every hour above a chosen biweekly threshold as overtime unless a qualified payroll professional has confirmed that calculation is correct for the situation.

Likewise, a break deduction should reflect the actual policy and applicable requirements. The sample formula subtracts the number entered in the break column, regardless of whether a break was paid or unpaid. If the template needs to capture paid breaks, multiple breaks, leave, on-call time, or different pay categories, add clearly defined fields and have the resulting calculations reviewed before using them to calculate wages.

A timesheet can support payroll review, but it does not replace approval or a payroll system. Consider adding a submission date and an approval field, while keeping corrections traceable. If a manager changes an entry, record why and who approved it rather than quietly replacing the original figure.

Sharing, copies, and privacy

Google Sheets makes collaboration convenient, but timesheets can contain personal work schedules and other sensitive employment information. Share only with the people who need access. Use the Share button to choose specific people and an appropriate role, such as Viewer, Commenter, or Editor. Avoid “Anyone with the link” access for employee records unless the organization has explicitly approved that arrangement.

A simple approach is to keep a clean master template with blank entry cells and formulas, then use File > Make a copy for each person or pay period. Check the copied file’s sharing settings: making a copy does not mean the new sheet should automatically be shared with everyone who could access the original. Store completed records in the organization’s approved location and follow its retention and access policies.

Common problems and practical fixes

The hours show as a clock time: change the calculated-hours cells to a number format. They represent decimal hours, not a time of day.
A shift across midnight gives a negative result: use the MOD-based formula above and confirm both entries are recognized as times, not plain text.
The result is too high or low: check whether the break is entered in decimal hours, whether it should be deducted, and whether start and end times were entered on the intended date.
Blank rows show unwanted values: confirm the formula includes the blank-entry check and that it was copied to the intended rows.
The total seems to omit a shift: check that the daily formula reaches every row and that the SUM range includes all 14 calculated-hour cells.
Two people edit the same template: use one copy per employee and period, or define a clear process for who owns each entry. Shared editing alone does not prevent conflicting or accidental changes.

Template choices and alternatives

A custom sheet gives control over columns, formulas, and approval steps, while a prebuilt Google Sheets template can save initial setup time. If you start from a template gallery file or a third-party download, inspect its formulas, permissions, and fields before entering real employee data. Remove features the team will not use, and test a copy with sample entries first. A basic daily-entry sheet is usually easier to audit than an elaborate dashboard no one maintains.

Sheets is a reasonable fit for a small team that needs a flexible shared record. A dedicated time-tracking or payroll system may be more appropriate when there are many employees, complex shifts, location requirements, approval workflows, or automatic payroll exports. Such tools may have subscription costs or setup requirements; compare their current terms and privacy controls rather than assuming a spreadsheet or app is universally better. A downloaded spreadsheet can also be opened in Excel, but menus, formatting behavior, and some formulas may differ. This setup is written for Google Sheets in a web browser.

Frequently Asked Questions

Does biweekly mean twice a month?
No. Biweekly normally means once every two weeks, producing a 14-day period. Twice monthly usually means two pay periods per calendar month, which are not necessarily 14 days long.

How do I make the dates fill automatically?
Enter the first date in the first daily row and the next calendar date in the row below. Select both cells and drag the fill handle down to continue the sequence. Review the final date to confirm the table spans 14 days.

Can the formula calculate a shift that ends the next day?
Yes. The MOD function in the example handles an end time earlier than the start time by treating it as a shift crossing midnight. Record separate rows for separate shifts, and ensure the shift length is plausible before submitting it.

Should the break column use minutes or decimal hours?
The example expects decimal hours: 30 minutes is 0.5 and 15 minutes is 0.25. Label the column with its unit. If you prefer another input method, adapt and test the formula rather than entering minutes into a field that subtracts hours.

Can I use the biweekly total to calculate overtime?
Not safely without knowing the applicable workweek and overtime rules. Keep the period total as a record of hours, and ask the employer’s payroll contact or a qualified professional how overtime and breaks should be classified.

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.