Timesheet Archives - HR Letter Formats

Timesheet Formula In Excel File Format

I have Attached Timesheet Formula


Employee ID:																																T	Percent
Employee Name:
Employee Designation:
Location:										Month / Year:			Apr			2012			NATIONAL STAFF PERSONNEL ACTIVITY REPORT													O
																																T
Date	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31	A
COST CENTERS:	Sun	Mon	Tue	Wed	Thu	Fri	Sat	Sun	Mon	Tue	Wed	Thu	Fri	Sat	Sun	Mon	Tue	Wed	Thu	Fri	Sat	Sun	Mon	Tue	Wed	Thu	Fri	Sat	Sun	Mon	###	L
																										O						0	0%
																																0	0%
																																0	0%
																																0	0%
																																0	0%
																																0	0%
																																0	0%
																																0	0%
																																0	0%
Total Hours:	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0%

TIME OFF:
Holiday																																0
Vacation																																0
Sick																																0
Unpaid																																0
Other																										8						8
Total Time Off:	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	8	0	0	0	0	0	8

																													Sick
																	Maximum Hours				ACCRUED TIME OFF						Vacation		Leave
																	Accrued Vacation										220		135.2
																	Permitted				Hours Beginning of Month						220		135.2
																											12		12
																	200	Hours			+ hours earned during month						12		12
																											0		0
																					– hours taken during month						0		0
																											232		147.2
																					Hours at End of Month						232		147.2


																	Employee Signature:												Date:


																	Supervisor Signature:												Date: