Attendance Tracking Formats: Which One Works Best for Your Team's Needs?

aruldsc
Dear Friends, I am Arul, M.Sc - MIS Manager. I've attached two different types of attendance report formats for you. This format will help you track attendance daily, weekly, and monthly.

Attendance Codes

- Present: P
- Half Day: 0.5
- Comp Off: CO
- Sick Leave: SL
- Casual Leave: CL
- Privileged Leave: PL
- Declared Holiday: H
- Sunday: S
- Absent: A
- Leave: L

Additional Codes

- Holiday: H
- Half Day: 0.5
- Holiday Work: HW
- Night Shift: N
- Sunday: S
- Sunday Work: SW
- Without Information Absent: WA
- Leave: L
- Official Travel: T

If there are any suggestions or improvements, please send me a query.

Thanks & Regards,
Arul,
Chennai.
[Phone Number Removed For Privacy Reasons],
[Email Removed For Privacy Reasons].
http://www.rapidcare.net
2 Attachment(s) [Login To View]

mahesh33chimanbhai
Dear sir,

This is a good and nice post, but I have one problem. If an employee is on half-day leave, how is it calculated? In your format, it shows as absence and does not calculate in total days.

Regards,
Mahesh
hr.sandip5
It's good, sir, but we need to add a formula for the half-day box.
If you are knowledgeable about any fact, resource or experience related to this topic - please add your views. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone. Join To Contribute