I am trying to format a timesheet I have created for multiple departments in our office. I am wanting:
1. Where the dates autofill when they select the period end date in the "WeekEndingDate" box (where the week ending date is a Sunday).
2. Auto calculate time to convert into quarter hours. I essentially want it to calculate like:
(MONDAYOUTLUNCH - MONDAYIN) + (MONDAYOUT-MONDAYINLUNCH) + "WorkFrom Home Hours" = "MONDAYTotal Daily" The employee would separate out their own time in the boxes named "MONDAYTotal Daily GL Hours" and "MONDAYTotal Daily Job Cost Hours"
I am not savvy with java scripts and the simple notations are not working.
I think that you have a complicated PDF to work with.
You can always get help here in the forums if you're willing to learn how to do your own scripts for your project.
As mentioned, this kind of calculation in Acrobat JS is not trivial.
I've developed a (paid-for) script that will allow you to set up such calculations quite easily:
However, excluding the lunch time requires a more complex script, which I can also write for you, for a small fee.
If you're interested you can contact me privately via [try6767 at gmail.com] to discuss it further.