Struggling with Monthly Attendance in Excel? Need Help with Leave Codes and Calculations?

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

Number of daily absences during the period multiplied by 100, divided by the average number of employees multiplied by the total number of workdays during the period, equals the absence rate.

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.