PDF Editing Issues

Calculate Regular, Overtime, and Double-Time Pay in an Adobe Acrobat PDF Form

Aamir Naveed AkramAamir Naveed Akram Nov 18, 2026 869 views

Question details

The user needs a timesheet PDF form to calculate pay using a job-position rate and regular, overtime, and double-time hours.

Calculate Regular, Overtime, and Double-Time Pay in a PDF Form
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the form editor

Open the PDF in Adobe Acrobat Pro and select All tools > Prepare a form. Check the field names in the form editor.

2
Check position export values

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.

3
Set the hourly rate

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;

4
Calculate total pay

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.

5
Set the calculation order and test

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 with PDF form field calculations
Check unrecognized positions: The example script sets the rate to 0 when the position does not match either export value. Add every valid position and verify the rate before relying on the total for payroll.
Calculate pay in WPS Spreadsheet

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. 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. 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. 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. 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.
Calculate regular, overtime, and double-time pay with a spreadsheet formulaOpen and save Microsoft Excel XLSX filesExport a completed timesheet as a PDFUse a familiar spreadsheet interface to review rates and hours
microsoft office alternative - wps office

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.