Hi, I work at a college. I am trying to build a form that will replace our
8-copy-carbonless form. The academic calendar is 9 payperiods that do not
start and end with months, but range from 30 to 31 day periods. For this
academic year the start was 08/21/06 and the end is 05/20/07. People start
and end on any day (paid by a 7 day week). Each day of each payperiod would
be a different fraction of the 9.000000 total.
The formula that I am trying to build takes the total salary for 9 months,
divides that by 9 multiplies that 1/9th by the appointment % which gives me
what that person will "actually be paid" for each pay period. Those parts I
have just fine.
This is where I'm stuck. I want to take that "actual pay" and multply it by
the fraction of 9.000000 that the start and end date represent for the total
encumbrance needed.
I have built a lookup table that gives each date it's fraction value.
for example, 08/23/06 = 0.096774 and 09/24/06 = 1.033333. (The first pay
period is 31 days).
So if a person earned $32,000/9=$3,555.56 per pay period with a 100%
appointment and worked from 08/23/06 to 09/24/06 they would earn
$3,555.56*1.033333 or a total of $3,674.07.
Thank You in advance, Jean