Weekly Excel Timesheet Template with Built-in Formulas

Gregory Jul 09, 2026

Streamlining your workweek just got easier with a Weekly Excel Timesheet Template equipped with formulas. This essential tool helps you track hours, calculate totals, and even visualize your workload. Let's dive into the world of Excel timesheets, their benefits, and how to create one with formulas.

Best 5 Timesheet Templates for Accurate Time Tracking in 2026 - Excel Word Template
Best 5 Timesheet Templates for Accurate Time Tracking in 2026 - Excel Word Template

First, why use a weekly timesheet? It offers a clear overview of your tasks, promotes accountability, and simplifies invoicing or payroll processes. Now, let's explore how to create an effective weekly timesheet template in Excel with formulas.

the weekly time sheet is shown in red and green
the weekly time sheet is shown in red and green

Setting Up Your Timesheet Template

Begin by creating a new Excel workbook. In the first sheet, name it "Timesheet Template". Here, you'll set up the basic structure of your timesheet.

FREE Excel Timesheet Template [DOWNLOAD]
FREE Excel Timesheet Template [DOWNLOAD]

In the first row, starting from column A, enter the following headers: "Date", "Day", "Task/Activity", "Start Time", "End Time", "Hours", and "Rate". Format the "Date" and "Day" columns as "Date" and "Text" respectively, using Excel's built-in functions.

Automating Day and Date

an employee timesheet is shown in the form of a blank sheet for employees
an employee timesheet is shown in the form of a blank sheet for employees

In cell B2, enter the following formula to auto-generate the day of the week: `=TEXT(TODAY(), "dddd")`. Drag this formula down to copy it for the rest of the week.

For the "Date" column (A), use the following formula in cell A2: `=EDATE(TODAY(),-1)+ROW()-1`. This will auto-generate dates for each row, starting from the previous day.

Calculating Hours Worked

Free Printable Timesheets | Template Business
Free Printable Timesheets | Template Business

In the "Hours" column (G), enter the following formula in cell G2: `=IFERROR((ENDTIME-SSTARTIME)/24,"")`. This calculates the hours worked by subtracting the start time from the end time and dividing by 24. If the cells are empty, it will return an error, which the IFERROR function will suppress.

Format the "Hours" column as "Number" with one decimal place for precision.

Adding Formulas for Totals

Excel Weekly Timesheet Template With Formulas
Excel Weekly Timesheet Template With Formulas

To summarize your weekly hours, add a new row below your timesheet. In cell A11, enter "Total Hours". In cell G11, use the SUM function to add up all the hours worked: `=SUM(G2:G9)`.

To display your total earnings, add another row. In cell A12, enter "Total Earnings". In cell G12, use the following formula to multiply total hours by your rate: `=G11*F2`. This assumes your rate is entered in cell F2.

Excel Timesheet Calculator Template [FREE DOWNLOAD]
Excel Timesheet Calculator Template [FREE DOWNLOAD]
Weekly Timesheet Template in Google Spreadsheets
Weekly Timesheet Template in Google Spreadsheets
How to Calculate Hours Worked and Overtime Using Excel Formula - ExcelDemy
How to Calculate Hours Worked and Overtime Using Excel Formula - ExcelDemy
Free Time Card Calculator for Excel
Free Time Card Calculator for Excel
Free Timesheet Template for Excel | Budget Spreadsheet Types By Timeframe, Excel Bill Payment
Free Timesheet Template for Excel | Budget Spreadsheet Types By Timeframe, Excel Bill Payment
Weekly Employee Timesheet: Excel Template (Digital Download)
Weekly Employee Timesheet: Excel Template (Digital Download)
Free Monthly & Weekly Timesheet Templates | Spica
Free Monthly & Weekly Timesheet Templates | Spica
How to Make a Time Sheet in Excel (with Formulas and Templates)
How to Make a Time Sheet in Excel (with Formulas and Templates)
Employee Timesheet Template in Excel (Download.xlsx)
Employee Timesheet Template in Excel (Download.xlsx)
FREE Calendar Templates
FREE Calendar Templates
my excel weekly planner
my excel weekly planner
a printable weekly time sheet with the words'company name'in black and white
a printable weekly time sheet with the words'company name'in black and white
Printable Timesheets Bi Weekly | Template Business PSD, Excel, Word, PDF
Printable Timesheets Bi Weekly | Template Business PSD, Excel, Word, PDF
a spreadsheet showing the company name and timesheet
a spreadsheet showing the company name and timesheet
Employee Timesheet Software
Employee Timesheet Software
Free Excel Leave Tracker Template (Updated for 2026)
Free Excel Leave Tracker Template (Updated for 2026)
the time sheet is shown in blue and grey colors, as well as white text
the time sheet is shown in blue and grey colors, as well as white text
Work Timesheet Excel | Templates at allbusinesstemplates.com
Work Timesheet Excel | Templates at allbusinesstemplates.com
Free Sample 30 Day Employee Time Sheet Template
Free Sample 30 Day Employee Time Sheet Template
Weekly Employee Time Sheet, Time Tracker, Editable Excel Spreadsheet (Printable)
Weekly Employee Time Sheet, Time Tracker, Editable Excel Spreadsheet (Printable)

Visualizing Your Workload

For a visual representation of your workload, insert a stacked area chart. Select your data (A1:G12), then insert the chart. This will help you see your workload distribution throughout the week.

Customize your chart by changing the series colors, adding a title, and adjusting the axis labels for a professional look.

Now that you've created your Weekly Excel Timesheet Template with formulas, you're ready to track your time effectively. Don't forget to update your template regularly to ensure accurate records. Happy tracking!