Semi-Monthly Timesheet Calculator
with Partial Week Overtime Calculations

[ Skip to Calculator ] Calcy pointing down

The Semi-Monthly Timesheet Calculator on this page will eliminate the pain of tracking overtime for workweeks that span two pay periods!

Veins in Forehead Bulging Out?

This calculator was created at the request of a site visitor who wrote:

Can you make this one? Overtime is calculated weekly over 40 hours, the pay periods are the 1st-15th & 16-EOM. Pay dates are the 13th and 28th. This is nearly impossible to figure out as some overtime is paid in the next pay period all the time and it is difficult to keep track of this on paper without the veins in my forehead bulging out!!

Turns out this email created a mental image that motivated me into action. I care too much about my site visitors to have them walking around with bulging veins in their foreheads.

Well, after a few bulging veins of my own I think I managed to come up with a way to reduce the swelling for the quoted visitor and for anyone else who can relate.

Note that if you pay on a weekly or biweekly basis, please select the appropriate calculator from my list of other available online employee time and wage calculators.

Easily Track Weekly Overtime for Semi-Monthly Pay Periods

If you have been trying to track weekly overtime for semi-monthly payroll periods on paper, I'm hoping the calculator on this page will help to reduce the swelling of the veins on your forehead that may be occurring during your semi-monthly payroll processing.

How so?

If you select the Overtime after 40 hours per week option, the Semi-Monthly Timesheet Calculator on this page will calculate the work time for the partial workweek that occurs at the end of the pay period -- and then includes that figure on the printable hours and wages report.

Next, the calculator provides a field at the top to enter the partial workweek time from the previous pay period report.

And finally, the calculator adds the previous partial workweek time to the current partial workweek time, calculates any overtime wages earned for the overlapping week, and then converts the appropriate current number of regular hours to overtime hours.

Viola! No more bulging veins ... at least I hope that is the case. If not, please let me know why not and I will do my best to correct the situation.

Note that if you pay different hourly rates for different types of work, please visit the Semi-Monthly Timesheet Calculator with Weighted Average Overtime, which can handle up to 5 different pay rates.

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.

If you would like to save multiple time sheets to a secure database -- making them accessible across all of your devices and web browsers -- please see the Ad-Free Cloud Version of this website.

With that, let's use the semi-monthly timesheet calculator to calculate pay period hours and gross wages for employees that are paid twice per month.

Semi-Monthly Timesheet Calculator
Calcy sign introducing the Semi-Monthly Timesheet Calculator

Instructions: If you would like the timesheet calculator to calculate the gross wages, complete the wage and overtime fields.

Next, select the starting and ending pay period dates, enter the carry-over hours from the last pay period (if applicable), and select your hour formatting preference.

Next, enter the applicable "in" and "out" times for each day you worked. You can enter times with or without the ":" (colon). For example you can enter 8:00 either as "8", "800" or "8:00". You can enter "10:45" either as "1045" or "10:45". For blocks of time that cover 12 or more hours, please use military times (Pop-up Military Time Conversion Chart). Just try to stay consistent with the format you use. In all cases the Printer Friendly Report will convert all entered times into hour:minute format.

Once you have completed the timesheet, click the "Calculate Semi-Monthly Payroll Hours and Wages" button. You will then have the opportunity to review the results before creating a printer friendly timesheet report.

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 Semi-Monthly Timesheet Calculator.

To design and print your own custom time entry forms, visit the Blank Time Sheet Creator.

Local Storage Feature: 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.

calcy treasure chest of features Save Your Work!

Just one of the Treasure Chest of Bonus Features you'll enjoy when you support the Ad-Free, Member Version of this site (for as little as 58¢ per month). See what you're missing!

Calculator Not Working? Please try disabling Ad Block for this page, as it may be blocking the code that runs the calculator.

Help Employee name
Help Hourly wage rate ($):
Help at X hourly rate:
Help Weekday your workweek starts on for OT purposes:
Help Payroll period starting date:
Help Payroll period ending date:
Help Hours:minutes from partial week of previous payroll period:
Help Time totals as hours:minutes or hours.hour-fraction?
Time Block 1
Time Block 2
Time Block 3
  In Out In Out In Out  
Help Total hours:minutes for pay period:
Help Period ending (optional):
Help Hours:minutes to carry forward for next period OT calculations:
Type Rate Hours (10ths) Pay
Help Regular:
Help Overtime:
Help Totals:
Please grade my work and help me improve:
If you liked this page, please share it, or give it a Like, +1, Tweet, or Pin.
calcy image pointing right

Semi-Monthly 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 wage 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 options: Optional: Select the Overtime option that best fits your payroll situation. If the employee is eligible for overtime pay, enter the factor that the regular rate is multiplied by and the calculator will calculate the hourly overtime rate for you. Or, simply enter your overtime rate in the far right-hand field. Note that if you select Overtime after 40 hours per week, then the weekday and partial week options will be enabled. Otherwise they will remain grayed out for the 3 other OT options.

Weekday your workweek starts on for OT purposes: If you selected Overtime after 40 hours per week, select the day of the week that the workweek starts on for the purpose of overtime calculations. If you pay overtime based on any other of the overtime options, then this menu is not applicable and will be disabled.

Payroll period starting date: Select the month, day, and year of the semi-monthly pay period you want the timesheet calculator to start at.

Payroll period ending date: Select the month, day, and year of the semi-monthly pay period you want the calculator to end at. The Day column will automatically be filled in with the correct days and dates. Note that in order for the calculator to operate, the number of days between the selected starting and ending pay period dates must be greater than 12 and less than 18. Timeframes that fall outside of 13-17 days will cause the In/Out fields to be cleared.

Hours:minutes from partial week of previous payroll period: If you pay Overtime after 40 hours per week, this field allows you to enter the time worked in a partial workweek from the last pay period. This time will be used to calculate any overtime that may be earned in the remainder of the workweek that occurs at the beginning of the current pay period. Note that the time must be entered in an HH:MM format (6 hours and 30 minutes would be entered as 6:30).

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.

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

In/Out columns: 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, please click on the pop-up military times conversion chart link in the top section of the calculator. The printer friendly report will reformat your entries to include the colons, regardless of how you enter the times.

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

Total time for pay period: This is the calculated sum of the time worked for the pay period. Note that this result may be in either a HH:MM or HH.HH format -- depending on your selected preference in the top section of the calculator.

Period ending: Optional: If you wish the printed timesheet to include the pay period ending date, enter the date here in whatever format you prefer. Note that the calculator will automatically populate this field with the date of the last day in the pay period.

Hours:minutes to carry forward for next period OT calculations: If you pay overtime for over 40 hours per week, this field will display the hours:minutes that will need to be carried forward for the purpose of determining overtime wages that may be earned in next pay period. If you pay overtime on any other basis this field will default to N/A.

Regular row: This row contains your employee's regular hourly rate, their total regular hours for the semi-monthly pay period, and their total regular wages.

Overtime row: This row contains your employee's overtime hourly rate, their total overtime hours for the semi-monthly pay period (which may include overtime wages stemming from a workweek that spans two pay periods), and their total overtime wages.

Total row: This row contains your employee's total hours and wages for the semi-monthly pay period.

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 Timesheet 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

> > Semi-Monthly Timesheet Calculator

+1 Page Site

Protected by Copyscape Online Plagiarism Detection
Calcy with money image
Top Ten Home
Money Calculators

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 month.

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!

* indicates required
Online Pocket Calc