If you need a free timesheet template that will let you record clock in/out times, try a professionally designed timesheet calculator listed below. A time sheet template isn't really meant to be the cure to all of your time management problems, but if you are looking for a very simple low-cost timesheet system, or want to create your own blank printable timesheet, Vertex42's templates are an ideal place to start.

Advertisement

If you don't want to record clock in and clock out times, check out our other free Excel Timesheet and Time Card templates. The free timesheet calculators on this page all involve entering the time in and time out to calculate total hours worked.

Time Sheet Template with Breaks

for Excel, OpenOffice and Google Sheets
Time Sheet Template with Breaks

"No installation, no macros - just a simple spreadsheet" - by

Download

⤓ Excel
For: Excel 2007 or later
⤓ Google Sheets

Other Versions

License: Private Use (not for distribution or resale)

Descriptioin

This standard version includes both a weekly timesheet and biweekly timesheet as separate worksheet tabs, as well as options for recording hours in decimal or [h]:mm format.

Time Sheet with 2 Breaks

Time Sheet Template with 2 Breaks

Download

⤓ Excel
For: Excel 2007 or later

License: Private Use (not for distribution or resale)

Descriptioin

This version allows you to include up to 2 breaks per day (or in other words, 3 separate clock in/out times). The file includes both weekly and biweekly worksheets in both decimal or [h]:mm time formats.

Overtime is calculated on a daily or weekly basis (or both).

More Free Time Sheet Templates

Cost: Free ($0.00)
License: View Agreement (Applies to all timesheets listed below)
Required: Microsoft Excel® 2002(XP), 2003, 2007, 2010, 2013 or OpenOffice
Monthly and Semi-Monthly Timesheet with Two Breaks
View Screenshot

Monthly & Semi-Monthly Timesheet (with 2 breaks)

timesheet-with-2-breaks_monthly.xls | Version 2.3.3

Based on the timesheet with 2 breaks, this version is for businesses that prefer to use a monthly timesheet or semi-monthly timesheet.

Original Employee Timesheet Template
View Larger Image

Original Employee Time Sheet with Breaks

This basic time sheet is based on our original design. If you just need to print a blank timesheet, this one is the easiest to customize. It requires you to manually allocate the Regular and Overtime hours.

Time Sheets with Breaks in Minutes

Are you looking for a way to specify the breaks in terms of minutes rather than having to record two or three separate clock-in / clock-out times? If so, the following two versions have been updated and renamed. Check them out on the new Time Card Calculator page.


Time Sheet with Breaks in Minutes
View Larger Image

Timesheet with Breaks in Minutes

This version has been updated for Excel 2007+ and is now part of a new time sheet template called the Time Card Calculator.

Time Sheet for California Overtime
View Larger Image

Time Sheet for California Overtime

timesheet-with-breaks-in-minutes_CA.xls | Version 2.3.3

This version has been updated for Excel 2007+ and is now part of our new free Time Card Calculator.

Time Sheet Instructions and Help

related blog articles
How to Use a Timesheet Template in Your Business - Share your experience and give feedback.

I don't provide support for customization or general questions about how to use Excel. However, I do have an interest in providing useful time sheet templates. So, if you have ideas or questions about how to use the timesheets, feel free to contact me.

Printing & Sending the Time Sheet to your Employer

Depending on how your employer wants to receive your timesheet, you might do one of the following:

  • Print and deliver/mail the completed time sheet.
  • If you have PDF conversion software, you could convert or print to a PDF and then email it.
  • Upload the completed time sheet to a secure shared server.
  • If your company uses an online time sheet system, you could update the Excel file throughout the week and then use it as a reference to complete the online form.

This timesheet template is pretty simple and it should be fairly intuitive. Hopefully, you'll go ahead and download it, figure out how it works, and customize it to suit the needs of your company. If you are an employer with many employees and this template doesn't meet your needs, you may want to consider looking into some kind of web-based time management system, or electronic punch card system.

Time Sheet Overtime Options

Overtime Options
Calendar reference and overtime options
within the timesheet templates.

Some of the time sheets contain formulas for calculating overtime based on a couple of basic optional rules:

  • Hours worked over 8 in a workday.
  • Regular hours worked over 40 in a workweek.

The screenshot below shows how easy it is to select the overtime options. You can enable just one of the options, or both, or none.

Overtime regulations vary from state to state and may contain many exceptions, so it may be necessary to enter overtime manually instead of using the formulas. If you have questions about the overtime requirements in your state, visit the U.S. Department of Labor website.

Follow Us On ...

FB  PIN  TWEET  LI  IG  YT 

Related Templates


Sponsored Listings 


   Share: