TimeSheet Calculation Step by Step Adobe Acrobat XI Pro

Question

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.

gkaiseril · Answer

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.

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