ckant_scs@yahoo.co.in
1

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
mr.suaky
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
adityaaccount9917
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
adityaaccount9917
Hello sir I want to the HR policy for trust. And what’s late coming policy for trust please revert asap.
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.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.