Skip to main content
aashan77
Participant
June 13, 2026
Question

Acrobat JavaScript Export Issue with Employee Timesheet Calculations

  • June 13, 2026
  • 0 replies
  • 1 view

Hi everyone,

I'm working on a PDF timesheet form in Acrobat where employees enter their daily start/end times and breaks. The form calculates total hours worked and exports the results to CSV.

The problem is that Acrobat JavaScript calculates everything in HH:MM format, but our payroll system requires decimal hours (for example, 7:30 should become 7.50). I've noticed small discrepancies when users manually convert the values before importing them into payroll.

For testing, I compared Acrobat's output with an external work-hours calculator that handles HH:MM to decimal conversion and overtime calculations: https://mauricettecalcul.fr/

Is there a recommended Acrobat JavaScript approach for accurately converting worked hours to decimal values before CSV export? Ideally, I'd like the PDF to generate payroll-ready figures automatically.

Thanks for any guidance.