I am using adobe acrobat extended pro, i am trying to get overtime amount. please help me finding the formulas.
text1: basic salary (3000); text2: overtime hours (25); text3: overtime amount to find.
Normal hours per day is 8, standard overtime is 1.5
Your description is not very clear. What should be the result in the overtime amount field, in the example you provided?
The overtime amount result should be 468.75 or round 469.00
I don't understand how you arrived to that result... Please elaborate.
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
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.
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.
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.
Copy link to clipboard
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.
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.