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
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