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 time sheets are an ideal place to start.

If you don't need to record clock in and clock out times, check out our other free timesheet and time card templates. The free timesheet calculator templates on this page all involve entering the time in and time out to calculate total hours worked.

Advertisement
Watermark - Time Sheet

Timesheet Template With Breaks

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

Standard Time Sheet Template with Breaks

timesheet-with-breaks.xls | Version 2.3.2

The 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 Breaks in Minutes
Screenshot

Timesheet with Breaks in Minutes

timesheet-with-breaks-in-minutes.xls | Version 2.3.2

This is a variation of the Standard version, where the amount of break time is entered in minutes instead of clocking in/out each time you take a break. This allows you to account for any number of breaks, yet still record the times that you arrived and left work.

Timesheet with Two Separate Breaks
Screenshot

Timesheet with 2 Breaks

timesheet-with-2-breaks.xls | Version 2.3.2

This version allows you to include up to 2 breaks per day (or in other words, 3 separate clock in/out times).


Advertisement
Monthly and Semi-Monthly Timesheet with Two Breaks
Screenshot

Monthly & Semi-Monthly Timesheet (with 2 breaks)

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

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

Time Sheet for California Overtime
Screenshot

Time Sheet for California Overtime

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

California's policies for overtime include rules for paying double-time as well as paying overtime for hours worked on a 7th consecutive day. This timesheet calculator has you enter breaks in minutes and includes an extra overtime column for calculating the double-time conditions. See calchamber.com for more information about California's specific overtime rules.

Original Employee Timesheet Template
Screenshot

Original Employee Time Sheet with Breaks

employee-timesheet-with-breaks.xls | Version 2.2

This basic time sheet is based on our original design. If all you need is something you can use to print a blank timesheet, this one is the easiest to customize. It requires you to manually allocate the Regular and Overtime hours, but for some people, that flexibility is preferrable.


Advertisement

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.

Share Our Free Time Sheet Calculator

If you like these timesheet calculators, please link to this page using the following URL:

http://www.vertex42.com/ExcelTemplates/free-timesheet-template.html

Like This Template?

Become a Fan

Vertex42's Facebook Page Vertex42's Google+ Page Vertex42's Pinterest Page
Excel training for your entire company