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

Time Sheet Calculator: Semi-Monthly: 3-Column: WOT Sign

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.

Specifically, 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.

The calculator then finds the weighted average hourly pay from the various rates entered and then divides that number in half 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.

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

Read more ...

Time Sheet Calculator: Semi-Monthly: 3-Column: WOT

Calculate semi-monthly time sheet hours and gross wages with 3 In/Out columns, up to 5 different rates, and the weighted average overtime method!

Special Instructions

Learn More

Selected Data Record:

A Data Record is a set of calculator entries that are stored in your web browser's Local Storage. If a Data Record is currently selected in the "Data" tab, this line will list the name you gave to that data record. If no data record is selected, or you have no entries stored for this calculator, the line will display "None".

DataData recordData recordSelected data record: None
Rates

Rate settings:

This section allows you to associate a rate description and hourly rate of pay for up to five different rate Id's. These numbers can be entered in the # field of each In/Out column.

Note that you can set the default rate number for each in/out column to 1, so you will want to enter the most common rate in the first row. You can also fix each # field so the time block column is automatically associated to corresponding rate id (choose "#1-5" from the default rate menu).

IdDescriptionRate
1
$
2
$
3
$
4
$
5
$
Default:Default rate:Default rate ID:Default rate ID to populate time blocks:

Default rate ID:

Choose the default rate ID you would like to populate each time block rate field with. Changing your selection after entering times will overwrite any existing rate id's with your selection.

If you choose None the rate fields will be blank. In this case you must enter a rate ID for all time blocks with entered In/Out times.

Choosing #1 will populate all rate fields with "1". You can change the default to the applicable rate id as you enter times.

Choosing #1-5 will populate the first time block with "1", the second time block with "2", and so on. This selection will also hidedisable the rate # fields to avoid unnecessary tabbing.

Period Settings

Period settings:

This section allows you to set the regular hour cap, the starting and ending pay period dates, and the daily time-total format.

Reg hours:Period regular hours:Pay period regular hours:Pay period hours before overtime kicks in:

Pay period regular hours:

Enter the number of pay period hours after which overtime kicks in.

#
Pay period start date:

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.

Pay period end date:

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.

Format:Time Format:Time totals format:Totals as hours:minutes or hours.hour-fraction:

Time totals as hours:minutes or hours.hour-fraction:

If you would like the calculator to display time totals in hours:minutes format (7:30), choose the HH:MM option.

Or, if you would like the calculator to display time totals in hours:fractions-of-hours format (7.5), choose the HH:HH option.

Clear Time Sheet for New Payroll Period:

If you're working with a saved set of entries, and would like to clear just the entered times for the current data record (leaving the payroll settings as they are), tap the button in this row. To commit the clearing of the timesheet to the saved data for this calculator, be sure to save the changes to the data record.

Enter Time Card Hours

Enter your time card hours:

Depending on the width of the calculator, a different entry form will be displayed. Narrow widths will display a mobile optimized form, whereas wider widths will display a desktop optimized form.

For each day in the period that you accumulated work time, tap the "+" icon to expand the day. Next enter the In and Out times for each time block you were getting paid for. Once each day is completed you can either leave the day expanded, or tap the "-" icon to collapse the In/Out times.

Important! When entering times only use numeric characters 0-9 with or without decimal points (no colons). The calculator will know that "130" means "1:30" and will insert the colons for you in the results.

Important! You can enter times in standard (130) or military (1330). However, if a time block exceeds a 12 hour period you will need to use military time instead of standard time. If you're not sure what the military time equivalent of a standard time is, tap the grid icon in this row to open the Military Time Conversion Chart.

# blocks:# time blocks:Number of time blocks:Number of time blocks per day:

Number of time blocks per day:

Choose the number of time blocks you would like to show for each day. This selection does not change any time field entries, it only shows and hides columnsenables and disables the column's entry fields.

Rate #1:Rate #1 time:Rate #1 time for pay period:Rate #1 time for pay period:

Rate #1 time for pay period:

This is the calculated sum of the hours associated to Rate #1 for all days worked in the pay period.

0:00
Rate #2:Rate #2 time:Rate #2 time for pay period:Rate #2 time for pay period:

Rate #2 time for pay period:

This is the calculated sum of the hours associated to Rate #2 for all days worked in the pay period.

0:00
Rate #3:Rate #3 time:Rate #3 time for pay period:Rate #3 time for pay period:

Rate #3 time for pay period:

This is the calculated sum of the hours associated to Rate #3 for all days worked in the pay period.

0:00
Rate #4:Rate #4 time:Rate #4 time for pay period:Rate #4 time for pay period:

Rate #4 time for pay period:

This is the calculated sum of the hours associated to Rate #4 for all days worked in the pay period.

0:00
Rate #5:Rate #5 time:Rate #5 time for pay period:Rate #5 time for pay period:

Rate #5 time for pay period:

This is the calculated sum of the hours associated to Rate #5 for all days worked in the pay period.

0:00
Total time:Total time:Total time for pay period:Total time for pay period:

Total time for pay period:

This is the calculated sum of the hours worked for all days worked in the pay period. If you selected the HH:MM format, this total will be listed as hours:minutes. Or, if you selected the HH.HH format, this total will be listed as hours.fraction-of-hours.

0:00
TypeRateHours
(10ths)		Pay
Rate #1:
Rate #2:
Rate #3:
Rate #4:
Rate #5:
Rates totals:
Overtime:
Totals:
Time Card Report

Time Card Report:

If you would like to print out a summary of the time card, enter or edit the ending date as you see fit, and then tap the "Printer Friendly Report" button.

Name:Name:Employee name:Employee name:

Employee name:

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

Period end:Period ending:Period ending date:Period ending date:

Period ending date:

Optional: If you wish the printed time card report to include the pay period ending date, enter the date here in whatever format you prefer.

If you would like to save the current entries to the secure online database, tap or click on the Data tab, select "New Data Record", give the data record a name, then tap or click the Save button. To save changes to previously saved entries, simply tap the Save button. Please select and "Clear" any data records you no longer need.

Help and Tools

Adjust Calculator Width:

Move the slider to left and right to adjust the calculator width. Note that the Help and Tools panel will be hidden when the calculator is too wide to fit both on the screen. Moving the slider to the left will bring the instructions and tools panel back into view.

Also note that some calculators will reformat to accommodate the screen size as you make the calculator wider or narrower. If the calculator is narrow, columns of entry rows will be converted to a vertical entry form, whereas a wider calculator will display columns of entry rows, and the entry fields will be smaller in size ... since they will not need to be "thumb friendly".

Show/Hide Popup Keypads:

Select Show or Hide to show or hide the popup keypad icons located next to numeric entry fields. These are generally only needed for mobile devices that don't have decimal points in their numeric keypads. So if you are on a desktop, you may find the calculator to be more user-friendly and less cluttered without them.

Stick/Unstick Tools:

Select Stick or Unstick to stick or unstick the help and tools panel. Selecting "Stick" will keep the panel in view while scrolling the calculator vertically. If you find that annoying, select "Unstick" to keep the panel in a stationary position.

If the tools panel becomes "Unstuck" on its own, try clicking "Unstick" and then "Stick" to re-stick the panel.

Military Time Conversion Chart
StandardMilitary
12:00 am (Midnight)0000
1:00 am0100
2:00 am0200
3:00 am0300
4:00 am0400
5:00 am0500
6:00 am0600
7:00 am0700
8:00 am0800
9:00 am0900
10:00 am1000
11:00 am1100
StandardMilitary
12:00 pm (Noon)1200
1:00 pm1300
2:00 pm1400
3:00 pm1500
4:00 pm1600
5:00 pm1700
6:00 pm1800
7:00 pm1900
8:00 pm2000
9:00 pm2100
10:00 pm2200
11:00 pm2300