Skip to main content
aashan77
Participant
June 13, 2026
Question

Acrobat JavaScript Export Issue with Employee Timesheet Calculations

  • June 13, 2026
  • 1 reply
  • 17 views

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.

1 reply

ls_rbls
Community Expert
Community Expert
June 24, 2026

Hi ​@aashan77 ,

 

Quick question: Does your time sheets calculate a single week or a full month?

 

Also, formatting the Start , End and Break fields to a time notation of HH:MM , expects the user to be aware of 24-Hour clock notation only. Anything after 12:00 starts at 13:00 (1PM), 14:00 (2PM) etc…

 

Assuming all users are ok with entering their times using only 24-Hour clock notation, there are indeed some JavaScript scripting ways to achieve this.

 

 

Technical Generalist