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
From India, Bangalore
1Dear 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
From India, Bangalore
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
From Philippines
From Philippines
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
From India, Rudrapur
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
From India, Rudrapur
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
Attendance-Sept ember-monthly.x ls
Employee Monthly Attendance.zip