Monthly Attendance Calculation
Dear All,
I want to calculate monthly attendance in Excel format. For example, P = Present, if anyone takes leave, I have to input SL = Sick Leave, A = Absent, CL = Casual Leave, WO = Weekly Off, PH = Paid Holiday, ML = Medical Leave, and others.
For example:
S.NO NAME 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
PRESENT DAYS WEEKLY OFF P. H. EL. SL. ML. DAYS FOR PAYMENT
X Y Z P P P P A P WO P P SL SL P P WO P P P P P P P WO P PH P P ML P EL WO EL
How do I calculate the above format? Can anyone help me, please?
Regards,
Cikant
Email ID: ckant_scs@yahoo.co.in
From India, Bangalore
Acknowledge(0)
Amend(0)
1Dear All,
I want to calculate monthly attendance in Excel format. For example, P = Present, if anyone takes leave, I have to input SL = Sick Leave, A = Absent, CL = Casual Leave, WO = Weekly Off, PH = Paid Holiday, ML = Medical Leave, and others.
For example:
S.NO NAME 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
PRESENT DAYS WEEKLY OFF P. H. EL. SL. ML. DAYS FOR PAYMENT
X Y Z P P P P A P WO P P SL SL P P WO P P P P P P P WO P PH P P ML P EL WO EL
How do I calculate the above format? Can anyone help me, please?
Regards,
Cikant
Email ID: ckant_scs@yahoo.co.in
From India, Bangalore
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)
From Philippines
Acknowledge(0)Amend(0)
Hello Sir,
I'm Narendra. I have one problem, please solve it. Actually, in our company, we follow in & out time, and salary is calculated as per the in & out timesheet. My problem is how to calculate total present, total absent, and OD, etc. Please share an Excel sheet with in & out time to calculate present.
From India, Rudrapur
Acknowledge(0)Amend(0)
I'm Narendra. I have one problem, please solve it. Actually, in our company, we follow in & out time, and salary is calculated as per the in & out timesheet. My problem is how to calculate total present, total absent, and OD, etc. Please share an Excel sheet with in & out time to calculate present.
From India, Rudrapur
Acknowledge(0)Amend(0)Looking for something specific? - Join & Be Part Of Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.
152120-very-use ful-hr-manageme nt-software-bui lt-excel-psa-hr -manager-mainta in-payrrol-exce l-soft.zip
Aligning HR Policies to Business Objectives.ppt
HR policies & procedures May 2007.pdf