Weekly Timesheet Calculator
With Lunch Break and Gross Pay

[ Skip to Calculator ] Calcy pointing down

The Weekly Timesheet Calculator on this page will help you reduce the time you are spending on manual payroll processing!

Would you like to spend less time manually processing payroll so you could spend more time growing your business?

That is exactly what the calculator on this page is designed to do.

Built From Experience

I created this calculator based on my own experience with spending countless hours manually processing payroll for as many as 40 of my own employees.

So unlike other timesheet calculators on the web, my goal was not to create a calculator that would wow you with fancy colors, bells, and whistles. Instead my goal was to help you process the timesheets as fast as possible so you can get back to growing your business asap.

How to Increase Employee Productivity

Contrary to popular belief, employee incentive plans rarely ever lead to any long-term increases in productivity.

And that's because all incentive plans -- cash or non-cash -- eventually fall victim to the law of diminishing returns.

The best way I have found to increase employee productivity, is to stop being a boss and instead become a coach.

Bosses order people around to boost their own egos, whereas coaches give their players the support, instruction, tools, and encouragement they need to increase their value to the team.

Coaching youth baseball alongside successful coaches for the past 15 years has taught me more about motivating people than any business book I've ever read.

From a motivational standpoint, adults are no different than kids. What they dream about most is the appreciation they will get when they make an important contribution to the team. A good coach will help turn those dreams into realities.

Time Saving Features

Here are the features that make this the fastest timesheet calculator on the web:

  • Non-numeric characters are optional.
  • Converts minutes into 10ths of hours for you.
  • Calculates gross wages -- including overtime -- at the same time.
  • Formats output into printable hours and gross wages report.
  • Allows you to correct mistakes without starting over.
  • No Back buttons or waiting for a results page.

If you happen across a faster online timesheet calculator, please let me know.

New! Save Entries Between Visits

If you are using a newer version of your web browser software (one that supports HTML5 Local Storage), you can now save your entries between visits -- either for yourself or for multiple employees.

However, please keep in mind that the saved entries can only be accessed from the device and web browser they were saved with. Also, Local Storage is not 100% reliable, and no backup method exists, so be sure to keep your paper records.

This feature is currently in Beta, so please contact me and let me know how the feature worked for you, and/or if you discovered any issues (include your web browser brand name and version number).

Other Versions Currently Available

If the timesheet calculator on this page doesn't meet your needs, here are your other options:

If none of the existing versions accommodate your timesheets, please contact me and explain your needs in detail and I will consider creating another version.

Or, if you have a suggestion for improving an existing version, please let me know that as well. Just be sure to reference the calculator by its web address (http://www.free-online-calculator-use.com/...html) so I know which calculator you are referring to.

With that, let's use the 2-column weekly timesheet calculator to calculate your employees' pay period hours and gross wages for the week.

2 Column Weekly Timesheet Calculator
Calcy sign introducing Weekly Timesheet Calculator


Instructions: If you would like the timesheet calculator to calculate gross wages, enter the employee's regular rate and any overtime rules that apply.

Next, enter the applicable "In" and "Out" times for each day of the week your employee worked. You can enter times with or without the colon (enter 9:00 either as "9", "900" or "9:00") and in standard or military time format.

For blocks of time that cover 12 or more hours, please use military times (see the Pop-up Military Time Conversion Chart). No matter how you enter the times, the Printable Timesheet Report will convert all entered times into a hour:minute format.

Once you have completed the timesheet, enter the employee name and period ending date as you would like them to appear on the printable report, and then click the "Calculate Hours and Wages" button.

Mouse over the blue question marks for a further explanation of each entry field. More in-depth explanations can be found in the glossary of terms located beneath the 2-Column Weekly Timesheet Calculator.

If you use Internet Explorer and you can't print the report, all I can suggest is that you try Google Chrome or FireFox instead.

Local Storage Feature Added on 7/2/2015: You now have the option to save your settings (pay period, OT option and multiplier, HH:MM/HH.HH, and employee names and wages), and entered in/out times (for you or any number of employees) between visits. Important! The saved data can only be accessed from the same computer and web browser that stored it, and there is no backup copy of the saved data. If you have used this calculator in the past, please reload/refresh the page (F5 on most keyboards) to make sure you are viewing the latest version.

To design your own printable time entry forms, visit the new Blank Time Sheet Creator.

Help Employee name
:
Help Hourly pay rate ($):
Help at X hourly rate:
Help Day of the week pay period starts on (or ):
Help Time totals as hours:minutes or hours.hour-fraction?
Help
Day
Help
Time Block 1
Help
Time Block 2
Help
HH:MM
  In Out In Out  
Help Total hours:minutes for the week:
Help Period ending (optional):
Help
Type Rate Hours (10ths) Pay
Help Regular:
Help Overtime:
Help Totals:
Help

2-Column Weekly Timesheet Calculator Glossary of TermsCalcy magnifying glass

Check Out My Other Super
Wage & Salary Calculators
To Help You To
Calculate Your ...
Super Calcy

Employee name: Optional: If you will be printing the completed time card report for a specific employee, enter their name here.

If your web browser supports Local Storage, you can also add multiple employees to the drop-down list, and then save their individual in-out times between visits.

To add an employee, select New, enter the name, and then click the Add button.

To add/edit in-out times for an employee, select their name from the menu, enter/edit the in-out times, and then click the Save Changes button. If you don't want an employees wage info saved, leave the wage fields blank when saving changes.

To remove an employee from the list, select the employee name and click the Delete button.

Hourly pay rate: Optional: Enter the regular hourly rate of pay for the employee you are entering in/out times for. If you are using the local storage feature, and you don't want the wage to appear for each employee, leave this field blank when saving changes to the employee.

Overtime rate: Optional: Select the Overtime option that best matches your pay situation. If your employee receives overtime pay, enter the factor that your regular rate is multiplied by and the timesheet calculator will calculate the hourly overtime rate for you. Or, simply enter the overtime rate in the far right-hand field.

Day of the week your workweek starts on: Optional: Select the day of the week you want the timesheet calculator to start at. The Day column will automatically be filled in with the correct sequenced days. If you want the date included for each day (example: Mon Jan 1), select the month and day of the first day of the pay period. This will also populate the Day column with the correct sequenced days. If you don't want the date include select N/A from the month drop-down menu.

Time totals as hours:minutes or hours.hour-fraction? If you would like the time totals formatted to hours and minutes, select HH:MM (7 and 1/2 hours will appear as 7:30). Or, if you would like the time totals formatted to hours and fraction of an hour, select HH.HH (7 and 1/2 hours will appear as 7.50). Note that you can switch from one to the other format at anytime during time entry process, at which time the calculator will automatically reformat the daily totals.

Time entry format: When entering In/Out times, you can enter the time with or without the colon (:). For blocks of time that cover 12 or more hours (6:00 am to 6:00 pm), please use military times (refer to the military time conversion chart link in the next paragraph).

Military time format: If you need to enter a time span that is 12 or more hours in length, please use the pop-up military time conversion chart to look up the military times you will need to enter ("0000" will not be read by the calculator). You can then keep that conversion chart window open to refer back and forth when you need to.

Day column: You can change the text in this column to whatever identifier you would like to show up on the report.

Block 1 column: This work period is normally the period before lunch break.

Block 2 column: This work period is normally the period after your lunch break.

HH:MM/HH.HH column: This calculated column will total up your worker's hours:minutes (or hours.hour) for each day, and then total up the hours:minutes (or hours.hour) for the week. Fields in this column recalculate as you enter or change times in the timesheet.

Period ending: If you want the printable timesheet report to include the pay period ending date, enter the date here in whatever format you prefer.

Regular row: This row contains your employee's regular hourly rate, their total regular hours for the week, and their total regular wages.

Overtime row: This row contains your employee's overtime hourly rate, their total overtime hours for the week, and their total overtime wages.

Total row: This row contains your employee's total hours and wages for the week.

Save Current Settings button: Click this button to save the overtime preference, hour format, and payroll period settings between visits.

Clear Sheets for New Pay Period button: Click this button to clear in-out times from all employee timesheets so you can start a new payroll period.

Clear All Data button: Click this button to delete all saved settings, employees, and in-out times.

Printer Friendly Timecard Report button: Clicking this button will open the displayed form in a new window for printing. If you need to email the form to a payroll clerk, your printer should have an option to print the report to a PDF file (saves PDF file to your hard drive). You can then attach the PDF file to the email you send to the clerk.

[ Return to Top of Calculator ] [ Return to Top of Page ] Calcy pointing up



> > 2-Column Weekly Timesheet Calculator



+1 Free-Online-Calculator-Use.com
+1 Page Site
Help


Protected by Copyscape Online Plagiarism Detection

Follow me on any of the social media sites below and be among the first to get a sneak peek at the newest and coolest calculators that are being added or updated each week.

Monthly What's New Email Update!

Who knows if I will show up in your next search. This will insure you'll always know what I've been up to and where you can find me!

Email

Name

Then

Don't worry -- your e-mail address is totally secure.
I promise to use it only to send you Whats New.
Online Pocket Calc
Help