Hi all,
I work at an IT company. Our total strength is around 120 employees. We need to maintain their attendance at the end of the month. Could you please advise on the format we should prepare for their attendance?
Thanks and regards,
Pooja
From India, Delhi
Acknowledge(0)
Amend(0)
2I work at an IT company. Our total strength is around 120 employees. We need to maintain their attendance at the end of the month. Could you please advise on the format we should prepare for their attendance?
Thanks and regards,
Pooja
From India, Delhi
Acknowledge(0)Amend(0)
Dear Pooja,
You may maintain the attendance in a simple Excel sheet only. Start with E-Code and Name of the employee, then put the column for Designation and Date of Joining. Then onwards date and month. Below them, mark Present, Absent, Leave, or Holiday. By this way, only you may maintain it in a very simple way. Moreover, at the end, put the formula and calculate all the Absent and leaves taken in that month.
Hope it will help you to do the same.
Regards,
Amit Seth.
From India, Ahmadabad
Acknowledge(0)Amend(0)
You may maintain the attendance in a simple Excel sheet only. Start with E-Code and Name of the employee, then put the column for Designation and Date of Joining. Then onwards date and month. Below them, mark Present, Absent, Leave, or Holiday. By this way, only you may maintain it in a very simple way. Moreover, at the end, put the formula and calculate all the Absent and leaves taken in that month.
Hope it will help you to do the same.
Regards,
Amit Seth.
From India, Ahmadabad
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.
LEAVE-ATTENDANC E POLICY.doc
Employee attendance tracker1.xls
Employee Monthly Attendance.zip