Leave calculation format

I Have Attached Leave calculation format

Leave calculation format

 
• 2 leave each month. No el/cl/pl leaves
• office timings: 10:00 am to 6:30 pm (punching is only here)
• short break: 20 mins (manual entry in register)
• deduction on late coming
• 10:00am- 6:30pm:- no deduction
• 10:00am-10:05am:- grace period
• 10:06am-10:15am:- ¼ of salary deduction (or) stay till 07:00pm
• 10:16am-11:30am:- ¼ of salary deduction
• 11:30am-02:00pm:- ½ of salary deduction
• half day: 10:00 1m-1:30 pm
• second saturay: Half day.
• if you leave at 4:30 pm on any day, your ¼ salary will be deducted.

Plz help me design leave register for employees ,,,where at the end i can tell

1) total number of working days of an employees
2) deduction of an employee
3) leave adjust of an employee.

__________________

Click Here To Download Leave calculation format

Leave calculation format

• 2 leave each month. No el/cl/pl leaves
• office timings: 10:00 am to 6:30 pm (punching is only here)
• short break: 20 mins (manual entry in register)
• deduction on late coming
• 10:00am- 6:30pm:- no deduction
• 10:00am-10:05am:- grace period
• 10:06am-10:15am:- ¼ of salary deduction (or) stay till 07:00pm
• 10:16am-11:30am:- ¼ of salary deduction
• 11:30am-02:00pm:- ½ of salary deduction
• half day: 10:00 1m-1:30 pm
• second saturay: Half day.
• if you leave at 4:30 pm on any day, your ¼ salary will be deducted.

Plz help me design leave register for employees ,,,where at the end i can tell

1) total number of working days of an employees
2) deduction of an employee
3) leave adjust of an employee.

__________________