Acrobat JavaScript Export Issue with Employee Timesheet Calculations
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.
