Step-by-Step Guide: Create Monthly Timesheets in Excel

Gregory Jul 09, 2026

Creating a monthly timesheet in Excel can be a straightforward task once you understand the basic steps. This tool can help you track your hours, manage projects, and invoice clients efficiently. Here's a simple guide to create your own custom timesheet.

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

Before we dive into the process, ensure you have Microsoft Excel installed on your computer. If you're using a Mac, you can use Numbers, but the steps might vary slightly. For this guide, we'll focus on Excel for Windows.

how to create a time sheet in excel
how to create a time sheet in excel

Setting Up Your Timesheet

First, let's set up the basic structure of your timesheet. Open a new Excel workbook and name it "Monthly Timesheet". In the first row, create headers for the following columns:

Progress Tracker in Excel – Visualize Your Goals & Milestones
Progress Tracker in Excel – Visualize Your Goals & Milestones
  • Date
  • Task/Activity
  • Start Time
  • End Time
  • Duration (in hours)
  • Rate (per hour)
  • Total (Amount)

Format the 'Date' column as a date, and the 'Duration', 'Rate', and 'Total' columns as currency. Freeze the top row for easy navigation.

Free Timesheet Templates | Daily, Weekly, Monthly
Free Timesheet Templates | Daily, Weekly, Monthly

Using Excel Tables

To make your timesheet more manageable, convert it into an Excel Table. This will allow you to sort, filter, and apply styles easily. Select any cell inside your timesheet data, then click on 'Format as Table' in the 'Home' tab. Choose a table style and ensure the 'My table has headers' box is checked.

Once converted, you can sort your data by date, task, or duration using the 'Sort & Filter' button. You can also apply conditional formatting to highlight cells based on specific criteria, such as tasks that exceed a certain duration.

the calculator timesheets in excel
the calculator timesheets in excel

Automating Calculations

To save time, you can automate the calculation of duration and total amount. In the 'Duration' column, enter the formula "=ENDTIME-STARTTIME" (without quotes). This will calculate the duration in hours. In the 'Total' column, enter the formula "=DURATION*RATE" to calculate the total amount.

Press Enter after each formula, and Excel will automatically fill in the rest of the cells. If you want to add or remove rows, simply click inside the table and start typing or deleting. The formulas will adjust accordingly.

how to create a time sheet in excel with overtime  Part 1
how to create a time sheet in excel with overtime Part 1

Customizing Your Timesheet

Now that you have the basic structure, you can customize your timesheet to fit your needs. Here are a few ideas:

Free Monthly Timesheet & Time Card Templates | Smartsheet
Free Monthly Timesheet & Time Card Templates | Smartsheet
Time Sheet Template with Breaks
Time Sheet Template with Breaks
Monthly Excel Timesheet Template | Editable & Automated Work Hour Tracker | Job Log Spreadsheet | Instant Download
Monthly Excel Timesheet Template | Editable & Automated Work Hour Tracker | Job Log Spreadsheet | Instant Download
Monthly Timesheet Template Excel | Template Business
Monthly Timesheet Template Excel | Template Business
Free Timesheet Template for Excel
Free Timesheet Template for Excel
a spreadsheet showing the company name and timesheet
a spreadsheet showing the company name and timesheet
Excel Time Sheet with Overtime 😍 Easy Formula (Beginner to Pro)
Excel Time Sheet with Overtime 😍 Easy Formula (Beginner to Pro)
Free Excel Leave Tracker Template (Updated for 2026)
Free Excel Leave Tracker Template (Updated for 2026)
Calender in Excel ‼️ Amazing Excel trick using data validation and conditional formatting ✅ #Excel
Calender in Excel ‼️ Amazing Excel trick using data validation and conditional formatting ✅ #Excel
Monthly Timesheet Template Excel Free Download - Free Sample, Example & Format Templates
Monthly Timesheet Template Excel Free Download - Free Sample, Example & Format Templates
Project Milestone Chart Using Excel | MyExcelOnline
Project Milestone Chart Using Excel | MyExcelOnline
Monthly Time Sheets - 10 Free PDF Printables | Printablee
Monthly Time Sheets - 10 Free PDF Printables | Printablee
Free Monthly & Weekly Timesheet Templates | Spica
Free Monthly & Weekly Timesheet Templates | Spica
How to Make an Availability Schedule in Excel (with Easy Steps) - ExcelDemy
How to Make an Availability Schedule in Excel (with Easy Steps) - ExcelDemy
Boost Productivity With 141 Free Sheets
Boost Productivity With 141 Free Sheets
Monthly Timesheet Template
Monthly Timesheet Template
Time Doctor Blog
Time Doctor Blog
How to Create a Month Calendar in Excel - Tutorial 📆
How to Create a Month Calendar in Excel - Tutorial 📆
Timesheet Template Free | Template Business
Timesheet Template Free | Template Business
Daily Work Tracker Excel: Essential Functions for Better Planning
Daily Work Tracker Excel: Essential Functions for Better Planning

Adding Projects or Clients

If you work on multiple projects or for different clients, you can add a new column for 'Project/Client'. This will help you track hours and generate invoices per project or client.

You can also create pivot tables or use the 'Slicer' feature to filter your timesheet data by project or client. This can provide valuable insights into where your time is spent and help with future planning.

Including Breaks

If you want to include breaks in your timesheet, you can add a new row for 'Break' with a start and end time. Subtract the break duration from your total hours to get your net working time.

Alternatively, you can use the 'Notes' column to record breaks and other non-billable activities. This can help you keep track of your day and ensure you're taking care of your well-being.

Creating a monthly timesheet in Excel can save you time and help you manage your work more effectively. With these steps, you can create a custom timesheet that suits your needs and helps you stay organized. Happy tracking!