JavaScript in Adobe Acrobat Pro

Nanaia

Active Member
Joined
Jan 11, 2018
Messages
306
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
I use Adobe to fill in time sheets. I figured out how to have it total the hours entered for the time period, but can't get it to calculate the hours for me. There are separate fields for time in (start shift), time out (lunch), time in (after lunch), and time out (end of shift). I've tried subtracting [ (end of shift-after lunch)+(lunch-start shift) ] in the following format using the field names (TIME OUTMON_2-TIME INMON_2)+(TIME OUTMON-TIME INMON) but keep getting a SyntaxError: missing ) in parenthetical 1: at line 2 error. I have nothing entered in JavaScript. My formula is one line. I understand that SyntaxError means I have something written incorrectly, however I can't find information on what might be incorrect. My JavaScript is novice at best although I have done some Python (not much). Can anyone tell me what I'm missing? I have the feeling I'm trying too much to make the formula like Excel but don't know how to change it.
 

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

Forum statistics

Threads
1,223,903
Messages
6,175,284
Members
452,630
Latest member
OdubiYouth

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top