TimeSheet Calculation Step by Step Adobe Acrobat XI Pro

Report · May 06, 2016

Hi Community. I am new with Adobe Acrobat and I need step by step information.

I have created a Timesheet for our organization (transitioning from XL to PDF).

I need:

1. To translate the Paying Cycle to Dates, populating 2 weeks day by day.

So say PC12 is from May 30 to June 12, I will have Monday to Sunday pre-written and beside it I want the date to populate including Sunday.

2. Then, to be able to record times in an easy way, and calculate the hours per day and hours per Cycle.

This is what I need:

Week 1 Day 1 Beginning Time: 8:00 pm

Week 1 Day 1 Beginning Time: 4:00 pm

Week 1 Day 1 Break Time: I want to be able to write 1/2 hour in a scroll down list and give me the value of 00:30 (Thirty minutes only)

The total per day in hours,

3. We want to have the total pero week, and per Cycle of 14 days.

4. We want the user to insert Lieu time, and volunteer time (we are a non-for-profit) and then discount this times from the result.

If you need the file I can send it to you, I don't see how to attach it here.

Please remember I am very new... so, please be patient with me.

Report · May 07, 2016

So how does one calculate the hours worked in one day with 2 beginning hour values and no ending hour values?

Have you looked at any tutorials about this?

Have you searched for any questions like this?

Have you searched for any tutorials about time and date calculations?

Unless you need the timesheet to cover any time between 1:00 am and 3:00 am, the period in which day light savings time change occurs, you can convert the time string into hours and miutes pieces and compute the mnutes or hours since midnight for both times and then compute the difference in hours or minutes for the time worked.

Report · May 07, 2016

I am so very sorry... it should read: Week 1 Day 1 Ending Time: 4:00 pm

And yes, I have done tutorials, and searched for similar questions. But I have not found anything that worked.

Report · May 08, 2016

If one has one week and the total for that week, you have almost half of the problem solved. You make a second week of fields with the appropriate named fields for the second week and total the daily totals for that week. The period total is the sum of each weeks total. This assumes that the daily hours worked value is expressed in minutes and the displayed format is set to how one want to display the hour worked.

How complex the code becomes depends upon how one names the fields. I have found the hierarchical field naming convention allows one to use some code to compute the field names to process and use control loops to compute each daily hours worked in one calculation, like the weekly total or the period total.