Timesheet Hours Worked Will Not Display Correctly

Question

I'm using Adobe Acrobat Pro DC.

I have four fields [amIN0, amOUT0, pmIN0, and pmOUT0] that will auto-populate the Hours Worked field.

My times are formatted to h:MM tt.

I need the HoursWorked results to display 7 hours and 30 minutes as 7.50 NOT 7.30

And 8 hours and 30 minutes should display as 8.50 NOT 8.70

I'm using a simplified notation (amOUT0-amIN0)+(pmOUT0-pmIN0).

Please help. Thank you.

try67 · Accepted Answer

Change the last line of the Regular Hours calculation to:event.value = Math.min(40, normalHours, totalHours);

try67 · Answer

You can't do it like that. Time calculations are much more complex than normal math calculations, and require a custom-made script.

There are good tutorials about this subject here:

https://acrobatusers.com/tutorials/working-with-date-and-time-in-acrobat-javascript

https://acrobatusers.com/tutorials/working-with-date-and-time-in-acrobat-javascript-part-2

https://acrobatusers.com/tutorials/working-with-date-and-time-in-acrobat-javascript-part-3

Alternatively, if you don't want to write the code yourself, I've developed a tool that allows you to easily set up this kind of calculation, including the option to show the result in decimal format (ie, 2.5 for two and a half hours, instead of 2:30): Custom-made Adobe Scripts: Acrobat -- Calculate Time Differences in a Worksheet

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded