Advanced Excel Timesheet

Runs in Microsoft Excel and Google Sheets
No monthly fees

Since 2000, ExcelTimeSheet has developed its timesheet for project and work time management.

ExcelTimeSheet supports a broad spectrum of work scenarios due to its rich capabilities. Generally speaking, two categories of customers are actively using our sheet.

Firstly, it is employees who prefer to maintain a complete overview of their work time for easy visualization and management of their projects.

Secondly, it is companies that desire to enable their people to log their hours effectively and prioritize their objectives with clarity.

Undoubtedly, there exist several time-logging solutions today. Are you satisfied with what you’ve got, or do you desire something more excellent and intuitive? We have created a well-driven timesheet we believe you and your staff would love to use, not only as an obligation but as an integral part of your professional lives.

DOWNLOAD THE EXCEL TIMESHEET

Why should I use ExcelTimeSheet?

In reality, any company or individual would benefit from using ExcelTimeSheet. The timesheet is quick to access and highly adaptable. It runs on all devices where Microsoft Excel is installed, such as a PC, Mac, tablet, iPad, or smartphone. It also runs well in Google Sheets.

Since ExcelTimeSheet comes as a single downloadable Excel file, there are no recurring fees. Consequently, the license is perpetual, and that’s the way we believe it should be.

You may watch this video, which gives you an introduction to how the timesheet functions.

When you first open the workbook, you recognize there is a separate worksheet per month in the year. Here, you have complete oversight of regular time, overtime, extra time, flexible time, sick leave, granted leave, and vacation. You may file up to three clock-in/clock-out intervals per day, and you can fill in the number of hours spent on each project against the time worked. For QC purposes, we use built-in formulas to enhance the user experience through auto-derivations and data control. The timesheet calculates week numbers and selected holiday dates based on the specified year. Therefore, when you first buy the Excel timesheet, you can reuse it forever.

In the following paragraphs, we explain how ExcelTimeSheet will benefit your business due to features making the workbook a robust and enjoyable tool that you can use to organize your time as part of your company’s EPM strategy.

Efficiency

Most importantly, ExcelTimeSheet is easy and intriguing to use. The monthly panels contain all the information needed and show you the big picture across projects. This means, you not only retain a record for organizational, archival, and potential accounting purposes. You also gain an oversight that positions you to prioritize goals and make informed decisions.

We have designed this sheet for everyone—from employers and employees to contractors and self-employed. The purpose of ExcelTimeSheet is to let you log and plan your time effortlessly. If you manage teams, you may provide them with this sheet to help them increase their capacity.

User-friendliness

The Excel timesheet is customizable in several ways. For instance, people from all countries that use the ordinary Gregorian calendar may specify any holiday and ‘red day’ according to their needs. You may also set your local language, as the timesheet supports 49 different languages. The sheet applies automatic calculations wherever possible and emphasizes internal control through data validations and error notifications. This eliminates redundancy and protects against non-intended input errors which may easily occur in a comprehensive worksheet.

Contents of the Excel Timesheet

In the paragraphs below we go quickly through each sheet in the workbook.

ReadMe—the first sheet

The ‘ReadMe’ sheet includes a practical Quick Start Guide and a User Manual.

Settings—a set of Options to Personalize Your Excel Timesheet

Then follows the worksheet called ‘Settings‘. This is where you specify the year, your work percentage, the number of daily regular work hours, the number of annual vacation days, and the core period (if applicable). You can also set parameters and switches for overtime, flexible time, extra time, used-named comments, etc.

At the bottom, you see a push button that deletes all the user input data from the monthly worksheets (this button is not included in the macro-free edition). This saves you some time when you’re going to prepare the worksheet for a new year.

Calendar—a Powerful Feature in the Excel Timesheet

The third tab is named ‘Calendar‘. Here you select the first day of the week (usually Monday or Sunday) and the preferred ‘red days’ and holidays. For convenience, we have predefined the most common Western holidays, such as New Year, Easter, Labor Day, Thanksgiving, and Christmas. Five US-specific holidays and the world’s national days are also listed. You may easily define any other holiday to match your country’s or company’s preferences. Simply tick the days on or off as preferred, and the timesheet will auto-compute the dates and week numbers based on the year you specified in the ‘Settings’ sheet and the selected first day of the week. Leap years are taken into account. This video provides a demonstration of how to use the calendar.

Projects—a Complete List to Partition Your Work

The next sheet is entitled ‘Projects‘. You may specify up to 99 projects in total. Each of them (optionally) has a start date and a projected end date. A bar displays the percentage of the total time used. In this video, you can see a presentation.

Monthly Panels

The monthly panels within the Excel timesheet are named ‘Jan’, ‘Feb’, etc. until ‘Dec’. Each of them includes a dateline with weekdays and week numbers.

When you arrive at work, you start by selecting the regular work hours for the day. You will notice that the column for today’s date is highlighted. You may specify the highlight color in the ‘Settings’ sheet. Then you type in your clock-in time. You may clock in and out up to three times per day, to account for lunch breaks, out-of-office meetings, travel hours, etc.

When that is completed, you continue by writing the number of hours of overtime, vacation, sick leave, and granted leave (whichever applies), as well as the number of work hours per individual project.

In the background, built-in formulas automatically derive the number of extra and flexible hours. These calculations are based on the selections in the ‘Settings’ sheet.

Interestingly, each monthly worksheet has a push button to filter the list of projects. This way, you don’t need to see any empty rows in the list. Another neat feature is the ability to sort the list of projects independently for each month while still preserving the calculated number of accumulated project hours per month and annually.

Hardware and Software

The user needs Microsoft Excel to operate the workbook. Alternatively, you may use the online Google Sheets editor. We have built the timesheet in the latest Excel version, with back-compatibility to Excel 2010.

To edit the timesheet, you may use any device—a Windows PC or a MacBook with either the Excel program or the Google Sheets web editor, or a tablet or phone via the Excel app or the Google Sheets app.

You may store ExcelTimeSheet locally, or access it remotely through an intranet or cloud storage, f.ex. OneDrive or Google Drive.

Microsoft Excel VBA

You can get the Excel timesheet in two editions: a VBA-enabled edition, where macros can run, and a VBA-disabled edition with no macros (*).

You may choose whichever edition you prefer if you run Excel as a standalone application or in Office 365 (not Online). We recommend going for the VBA-enabled edition.

However, if you use the Excel mobile app or Excel Online, you should choose the edition without macros, as these Excel applications do not support VBA at the time of writing.

The benefit of selecting the edition with macros is it includes pushbuttons for filtering projects and a button for deleting input data to prepare the workbook for a new year. The macro-free edition does not contain these buttons. However, you can still carry out the pushbutton operations in the macro-free edition. See the User Manual for how to accomplish this.

_{(*) A ‘macro’ is a script, created in Excel by recording mouse clicks and keystrokes. When you run the script, for instance when a button is pressed, those actions are repeated. Macros are coded in VBA (‘Visual Basic for Applications’).}

Copyright

There is a copyright on ExcelTimeSheet. However, if you oversee a team, you may freely distribute it to your people for internal use within your organization.

Download the Excel Timesheet

In order to purchase and download the Excel timesheet, click below.

Contact Us

We would love to hear from you and answer your questions. You can find our contact information here.