Can I add a formula and automatic calculations of overtime amount in Pdf?

New Here ,
Jun 27, 2018

Copy link to clipboard

Copied

Hellow experts,

I am using adobe acrobat extended pro, i am trying to get overtime amount. please help me finding the formulas.

Lets say:

text1: basic salary (3000); text2: overtime hours (25); text3: overtime amount to find.

Normal hours per day is 8, standard overtime is 1.5

TOPICS
Acrobat SDK and JavaScript

Views

194

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

Can I add a formula and automatic calculations of overtime amount in Pdf?

New Here ,
Jun 27, 2018

Copy link to clipboard

Copied

Hellow experts,

I am using adobe acrobat extended pro, i am trying to get overtime amount. please help me finding the formulas.

Lets say:

text1: basic salary (3000); text2: overtime hours (25); text3: overtime amount to find.

Normal hours per day is 8, standard overtime is 1.5

TOPICS
Acrobat SDK and JavaScript

Views

195

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Jun 27, 2018 0
Most Valuable Participant ,
Jun 28, 2018

Copy link to clipboard

Copied

Your description is not very clear. What should be the result in the overtime amount field, in the example you provided?

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Jun 28, 2018 0
New Here ,
Jun 28, 2018

Copy link to clipboard

Copied

The overtime amount result should be 468.75 or round 469.00

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Jun 28, 2018 0
Most Valuable Participant ,
Jun 28, 2018

Copy link to clipboard

Copied

I don't understand how you arrived to that result... Please elaborate.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Jun 28, 2018 0
New Here ,
Jun 28, 2018

Copy link to clipboard

Copied

3000(BS)/30(days per month)/8(normal hours per day)*1.5(standard OT rate)*25(total OT hours)=468.75

Text1: 3000, Text2: 25, Text3: should read 468.75 or round amount 469.00

Thanks

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Jun 28, 2018 0
Most Valuable Participant ,
Jun 29, 2018

Copy link to clipboard

Copied

So it's dependent on the number of days in that month, too? That's not a trivial thing to find out and adds an additional layer of complexity to the formula. You would need to use a script that parses the dates and then a function that finds out how many days were in that month.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Jun 29, 2018 0
Adobe Community Professional ,
Jun 29, 2018

Copy link to clipboard

Copied

In the U.S. overtime is either computed on the number of hours worked in one day or worked in a week.

For the daily option, any hours over 8 hours is considered overtime.

Example:

Monday     worked 8 hours

Tuesday    worked 9 hours - 8 hours regular time and1 hour overtime

Wednesday worked 0 hours

Thursday     worked 10 hours - 8 hours regular time and 2 hours overtime

Friday        worked 8 hours

Total hours worked 35 hours 32 hours regular time and 3 hours overtime

For the weekly option, the hours above 40 hours would be overtime hours, For the above example there is no overtime since the total hours worked in the week did not exceed the 40 hour base for regular time.

Please clearly explain how you are computing the overtime.

Not all months have 30 days.  7 Months have 31 days, 4 months have 30 days, and one month has either 28 days or 29 days.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Jun 29, 2018 0
Most Valuable Participant ,
Jun 28, 2018

Copy link to clipboard

Copied

You need to start by understanding the math completely. So you could work this out on paper. Only then can you start to write the code. There's nothing built in that knows how to do salary calculations.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Jun 28, 2018 0
Adobe Community Professional ,
Jun 28, 2018

Copy link to clipboard

Copied

Since your overtime hours are based on the hours worked in one day over 8 hours, you will need to calculate the hours worked in a single day and then compute the non-overtime hours for the day and the overtime hours for that day. For a weekly time sheet you will need to calculate the non-overtime hours for the week and the overtime hours for the week. You may also want to  include some way to check that all hours worked are accounted for as non-overtime hours and overtime hours.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Jun 28, 2018 0