WOT Semi-Monthly Timesheet Calculator
For Up To 5 Different Pay Rates

[ Skip to Calculator ] Calcy pointing down

The Semi-Monthly Timesheet Calculator on this page will calculate up to 5 different rates of pay, plus use the weighted average method to calculate overtime!

Multiple Pay Rates? Average OT Method?

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

I own a company who deals with the Developmentally Disabled and in the past I have not had to pay overtime under FSLA for the personal care and respite services (companionship services) but now I do.

My employees have 3 different rates that they are paid and we are paid twice monthly. I use the weighted method for figuring overtime. Do you have a program that will figure this for semi-monthly paychecks?

To be honest, I had never heard of the weighted method for calculating overtime, but the visitor was kind enough to send me the formula. And viola! The calculator has become a reality!

Note that if you pay on a semi-monthly basis, but you use one of the traditional overtime methods, please visit the original semi-monthly timesheet calculator.

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

Easily Track Pay Period Hours for Multiple Hourly Rates

If you or your employees are paid different rates for different jobs, this calculator allows you to assign each rate to a number, and then assign each In/Out time block to the applicable number.

The calculator will then total up the hours and wages for each rate of pay, plus calculate the total regular wages for the pay period.

Weighted Average Overtime Method

If your company falls under FSLA's personal care and respite services category, and you are required to pay overtime based on the weighted average method, this calculator has you covered.

The calculator finds the weighed average hourly pay from the various rates entered, and then divides that number in half in order to arrive at the hourly overtime rate.

Next, if the number of hours worked exceeds the overtime threshold, the calculator multiplies the overtime eligible hours by the hourly overtime rate to come up with the amount of overtime pay to add to the regular wages.

With that, let's use the weighted average semi-monthly timesheet calculator to calculate wages and overtime for employees that have multiple rates of pay, and that are paid twice per month.

WOT Semi-Monthly Timesheet Calculator
Calcy sign introducing the Weighted-Average Overtime Semi-Monthly Timesheet Calculator


Instructions: If you would like the timesheet calculator to calculate the gross wages, complete the rates fields and enter the accumulated number of hours required before overtime kicks in.

Next, select the starting and ending pay period dates 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 Rate 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 WOT Semi-Monthly Timesheet Calculator.

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

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). Watch the Video Tour to 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
Rate #
Help
Rate Descriptions
Help
Rate
1
2
3
4
5
Help Number of pay period hours before overtime kicks in:
Help Payroll period starting date:
Help Payroll period ending date:
Help Time totals as hours:minutes or hours.hour-fraction?
Help
Day
Help
Time Block 1
Help
Time Block 2
Help
Time Block 3
Help
HH:MM
  In Out R# In Out R# In Out R#  
Help Rate #1 time for pay period:
Help Rate #2 time for pay period:
Help Rate #3 time for pay period:
Help Rate #4 time for pay period:
Help Rate #5 time for pay period:
Help Total hours:minutes for pay period:
Help Employee Name (optional):
Help Period ending (optional):
Type Rate Hours (10ths) Pay
Help Rate #1:
Help Rate #2:
Help Rate #3:
Help Rate #4:
Help Rate #5:
Help Rates totals:
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

WOT 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

Rate #: This column contains the rate number that will be associated to each rate description and hourly rate of pay. This number can be entered in the R# column of each In/Out column. Note that the default rate number for each in/out column will be set to 1, so enter the most common rate in the first row.

Rate Descriptions: For each separate rate of pay, enter a short description.

Rate: For each separate pay rate, enter the associated hourly rate of pay.

Number of pay period hours before overtime kicks in: Enter the number of pay period hours after which the overtime rate kicks in.

Payroll period starting date: Select the month, day, and year of the semi-monthly pay period you want the timesheet calculator to start 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.

Payroll period ending date: Select the month, day, and year of the semi-monthly pay period you want the timesheet 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.

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.

Time Block Columns: Enter the In time, Out time, and R# (rate number) for each applicable workday. 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.10ths-of-hour) for each day, and then total up the hours:minutes (or hours.10ths-of-hour) for the pay period. Fields in this column recalculate as you enter or change times in the timesheet.

Rate time for pay period: This is the calculated sum of the hours associated to each rate for all days worked in the pay period.

Total hours:minutes or hours:hundredth-hour for pay period: This is the calculated sum of the total hours worked for all rates types in the pay period.

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

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.

Rate rows: These rows contain the hourly rate, total hours, and total wages associated to each rate.

Rates totals row: This row contains the weighted average hourly rate, and the total hours and total wages for all rate types.

Overtime row: This row contains the weighted average overtime rate (weighted average hourly rate divided by 2), the total number of hours that are eligible for overtime, and the total overtime wages.

Totals row: This row contains your total hours and gross wages for the pay period.

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



> > WOT Semi-Monthly Timesheet Calculator



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


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
Help