Pto calculator

[steve89]

hello all i have a few formulas running and the breakdown is below. I have a page which is called PTO Hour Settings" which the sheet "Employees" references. A manager is to input what information applies to his account in the PTO hour setting page so this formula needs to be universal. The bottom cells on PTO Hour setting are A11:C14. Managers will enter there facility accrue or tenure rates there. problem with current formula is that its not accruing any numbers which in this case accrues every 12 months. The sick and personal should have its own formula per manager selection which has an option on how it accrues per year

Excel Workbook
	A	B	C	D	E	F	G	H
4	Vacation Accrue Amounts for 1 year			Sick Accrue Amounts per year			Personal Accrue Amounts per year
5	Amount of Time it Accrures Per Year	1		Amount of Time it Accrures Per Year	6		Amount of Time it Accrures Per Year	6
6	Food Service Director	5.00		Food Service Director	0.00		Food Service Director	0.00
7	Assistant Manager	5.00		Assistant Manager	0.00		Assistant Manager	0.00
8	COOK	5.00		COOK	6.00		COOK	6.00
9	Dietary Aide	5.00		Dietary Aide	6.00		Dietary Aide	6.00
10	Receiver/Utility	5.00		Receiver/Utility	6.00		Receiver/Utility	6.00
11
12	12 MONTHS	1 WEEK	80
13	24 MONTHS	2 WEEKS	120
14	8 YEARS	3 WEEKS	160
15	15 YEARS	4 WEEKS	pto hours earned
PTO Hours Settings

Excel Workbook
	B	C	D	E	F	G	H	I	J	K	M	N	O
3	EMPLOYEE NAME	Uniform Size	Shoe Size	START DATE	TERMINATION DATE	Title	Anniversary	Months Since Anniversary	Status	EMPLOYEE ID	Vacation	Sick	Personal
4	SYRETTA SMITH	L	9	6/1/2003		COOK	6/1/2019	14	FULL TIME	Y85015	0	0	0
EMPLOYEES