Monthly Attendance Calculation

Monthly attendance calculation
Dear All,
I wants to calculate monthly attendance in excel format, like P= present, if anyone getting leave so in that sheet I have to put SL = Sick Leave, A = absent, CL = casual Leave, WO = Weekly off, PH = Paid Holiday, ML = Medical Leave and others.
for eg.
S.NONAME123456789101112131415161718192021222324252 627282930PRESENT DAYSWEEKLY OFFP. H.EL.SLMLDAYS FOR PAYMNETX Y ZPPPPAPWOPPSLSLPPWOPPPPPPWOPHPPMLPELWOELEL
how to calculate above format, can anyone help me please.......
cikant
my email ID is [Login to view]

No. of Daily Absences during the period multiply by 100 divide by Average No. of employees multiply by Total No. of Workdays during the Period = Absence Rate

Hello Sir,
I m Narendra i have one problem please solve it actually in our company follow in & out time and salary calculate as per in & out time sheet. sir my problem is how i calculate total present & total absent and OD etc. please share excel sheet with in & out time with calculate present

Hello sir I want to the HR policy for trust. And what's late coming policy for trust please revert asap.