Calculate Regular, Overtime, and Double-Time Pay in an Adobe Acrobat PDF Form
Question details
The user needs a timesheet PDF form to calculate pay using a job-position rate and regular, overtime, and double-time hours.

- Product
- Adobe Acrobat Pro PDF forms
- Device & OS
- not provided
- Scenario
- An employee selects a position and enters hours into a timesheet form.
- Observed behavior
- The form should populate the corresponding hourly rate and calculate total pay using the applicable hour multipliers.
Open the timesheet in Adobe Acrobat Pro and check the exact names of the position, rate, hours, and total fields. Confirm the position field's export values and the hourly rates and overtime multipliers you intend to use.
Calculate timesheet pay with PDF form field calculations
Use a position field's export value to set the hourly rate, then calculate total pay from the hours fields.
This example uses EmployeeBox1 for the position, Base_Rate1 for the rate, and ST, OT, and DT for regular, overtime, and double-time hours. Replace these names and rates with those in your form.
Open the PDF in Adobe Acrobat Pro and select All tools > Prepare a form. Check the field names in the form editor.
Open the properties of the EmployeeBox1 dropdown and check its Options tab. Ensure the export values match the position names used in the rate script, such as Manager and Field Tech.
Open the Base_Rate1 field properties, select Calculate > Custom calculation script, and choose Edit. Enter: var position = this.getField("EmployeeBox1").valueAsString; event.value = position === "Manager" ? 35 : position === "Field Tech" ? 45 : 0;
Open the total-pay field properties, select Calculate > Simplified field notation, and enter: (ST + OT * 1.5 + DT * 2) * Base_Rate1. Use the exact field names from your form.
In Prepare a form, open the field calculation order option and place Base_Rate1 before the total-pay field. Close the form editor, select a position, enter hours, and verify the result. At $35 per hour, 8 regular hours, 4 overtime hours, and 1 double-time hour should total $560.

Calculate timesheet pay in WPS and export a PDF
Use WPS Spreadsheet to calculate pay from an hourly rate and hours, then export the completed timesheet as a PDF. The exported PDF is a static record and will not recalculate when its contents are changed.
- 1. Create a timesheet: Open WPS Spreadsheet and create a workbook with columns for position, hourly rate, regular hours, overtime hours, double-time hours, and total pay.
- 2. Enter the rate and hours: Enter the employee's position, hourly rate, and hours in a row. For example, put the rate in B2 and regular, overtime, and double-time hours in C2, D2, and E2.
- 3. Calculate the total: In the total-pay cell F2, enter =(C2+D2*1.5+E2*2)*B2. Check the result against the employee's rate and hours.
- 4. Export the completed timesheet: Choose Menu > Export to PDF and save the completed timesheet. Make future changes in the spreadsheet and export a new PDF.

Frequently Asked Questions
Why is the hourly rate showing as zero?
Check the position field's Options tab in Prepare a form. Its export value must match a value in the Base_Rate1 calculation script; the example assigns 0 to unmatched positions.
Why doesn't the total update after I change the position?
In Prepare a form, check the field calculation order and place Base_Rate1 before the total-pay field. Also confirm that the script and formula use the exact field names.
How is the example total of $560 calculated?
At $35 per hour, 8 regular hours, 4 overtime hours at 1.5 times the rate, and 1 double-time hour at twice the rate give (8 + 4 × 1.5 + 1 × 2) × $35 = $560.
Will a PDF exported from WPS Spreadsheet recalculate when I change it?
No. The exported PDF is a static record. Change the hours or rate in WPS Spreadsheet, then export the updated timesheet to PDF again.




