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(1)
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(1)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)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
Aligning HR Policies to Business Objectives.ppt
SBudget Format HR.xls