Need help understanding

can some one tell me why it is that paid time off hours are different from one pay period to the next my figures aren't the same as my employers. we are paid bi-weekly every other Monday and we have 26 pay periods per year. I've been with the company for 8 years. my paid time off works this way. http://www.excelforum.com/images/attach/xlsx.gif

years of srv. 8 annual days 20 maximum days 160 rate per hr 0.0770 that is 6.16 per bi-weekly pp.
some times they paid it at 6.15 other times it's at 6.16 if possible can some one explain it to me why and maybe show me a formula that that will figure it out for me in excel. I've tried to attach my excel work sheet on here but it isn't bring it up.

When the table has 6.15 it's because the formula has subtracted 1%

Formula:

Please Login or Register  to view this content.

Why that has been written in that way, you'll need to ask whomever has written it

The accrual rate in col G is incorrect; it should be 20 (days) / 26 (pay periods) / 80 (hrs / pp) ~ 0.07692308... , not 0.077. So the accrual per 80 hours is actually 6.1538...

The formulas in the workbook are someone's hack at making it turn out more or less correctly by bouncing back and forth between 6.15 and 6.16.

Hi Robert,

Thanks for the rep! But, I think that shg explained that the discrepancy was to account for rounding error.

In a year there are 52 weeks and 5 workdays each week for 260 workdays so, after 5 years your reward is 20/260=.076923077...
and that times 80 is 6.1538.....

So your table, with one more decimal:

Data Range

	T	U	V	W	X
1	Years of Service	Annual Accrual Days	Maximum Accrual	Accrual Per Hour	Accrual Per Bi-Weekly PP
2	0	10	80	0.03846	3.077
3	1	12	96	0.04615	3.692
4	2	15	120	0.05769	4.615
5	5	20	160	0.07692	6.154
6	10	25	200	0.09615	7.692

You're welcome!