Free Time Card Calculator

1. Edit the Company Name, Employee Name and other fields in the header area.

2. Enter a date in the Week Starting cell. The mini calendar to the right of the timesheet can be used as a reference.

3. If you do not want to display wage and pay information, you can delete or hide those rows.

4. Clear the sample values in the Time In, Time Out, and Break columns and then save the time card. At this point, you may want to save the customized time card as a template file to use for future time cards.

To enter a time value in Excel, you must include the colon (:) and leave a space between the time and the AM or PM. You can also enter a 24-hour time value like "14:15" without entering "AM" or "PM."

TIP: To quickly enter the current time, press CTRL+Colon (CTRL+SHIFT+;). This is easy to remember because times are displayed with a colon.

Here are some ideas for ways to send or share your timecard with your employer each week:

• Print and hand-deliver your time card.
• Save the timesheet as a PDF by exporting to a PDF, using a PDF print driver, or if you are using Excel 2010+ just go to File > Save As > and choose PDF.
• Upload your finished time card to a private secure server (ask your manager about this). If using Google Drive, you could share the spreadsheet with your manager.
• Even if your company uses some other time reporting system, you can still use this time card calculator by printing a blank version to update throughout the week.

These time card calculators allow you to calculate overtime based on a couple of 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, both, or none.

Calendar reference and overtime options
within the timesheet templates.

Overtime regulations vary from state to state. The overtime options allow this calculator to work in most states (including California - see below).

If there is a special exception, it may be necessary to enter overtime manually instead of using the formulas. If that is the case, then just copy the cells under the Sick column and paste them into the Overtime column and enter the overtime hours manually.

If you have questions about the overtime requirements in your state, visit the U.S. Department of Labor website (this page, specifically).

Unlike most other states that have very simple overtime rules, California's policies for overtime include rules for paying double-time as well as paying overtime for hours worked on a 7th consecutive day.

We've included separate worksheets within each of the above files for handling these more complicated rules.

See hrcalifornia.calchamber.com for more information about California's specific overtime rules.

The formula that calculates the Total Hours Worked needs to be able to handle a period that spans midnight. A time in Excel is stored as a fraction of a day, so 1 hour is 1/24 and one minute is 1/1440. If you enter the In time as 8:00 PM and the Out time as 5:00 AM, you can't just subtract the values to calculate the total hours.

When calculating hours worked each day from the clock-in / clock-out times, the template rounds to the nearest minute. If your company requires a different type of rounding, let us know.

In the Total Hrs column, change the MROUND(...,1/60) function to FLOOR(...,15/60). This will round 0-14 minutes to 0, 15-29 minutes to 15, etc.