Hi Friends,
Here, I am posting a good "Daily Attendance Sheet Format" that helps in calculating the daily attendance of employees in small firms. You simply need to input 1 for present days, c-offs, and 0.5 for half-days accordingly. For beneficial leaves, manual calculation is required. Please refer to the Legend for each type of beneficial leaves, offs, holidays, absences, etc. This sheet will surely be helpful to everyone.
From India, Pune
Acknowledge(2)
Amend(0)
74Here, I am posting a good "Daily Attendance Sheet Format" that helps in calculating the daily attendance of employees in small firms. You simply need to input 1 for present days, c-offs, and 0.5 for half-days accordingly. For beneficial leaves, manual calculation is required. Please refer to the Legend for each type of beneficial leaves, offs, holidays, absences, etc. This sheet will surely be helpful to everyone.
From India, Pune
Acknowledge(2)Amend(0)
Microsoft Excel is designed in such a way that it can calculate everything and anything. In your current format, you have used manual calculations. Instead, you should use formulas to obtain the results. It would be beneficial for you to focus on improving your Excel skills.
Thanks,
Srinivas
From India, Hyderabad
Acknowledge(0)Amend(0)
Thanks,
Srinivas
From India, Hyderabad
Acknowledge(0)Amend(0)
Dear Ameeta,
Coming late is a common problem with the staff. Just observe for a week who all fall into this category of coming late and point it out whenever they arrive late at the office! Ask them the reason for being late. If you do this regularly, one day they will start coming on time. It doesn't matter if they are running late; one has to be punctual in their daily routine. Initially, you may feel uncomfortable pointing it out repeatedly, but this is the only way to deal with latecomers.
Neelanjana
From India, Pune
Acknowledge(0)Amend(0)
Coming late is a common problem with the staff. Just observe for a week who all fall into this category of coming late and point it out whenever they arrive late at the office! Ask them the reason for being late. If you do this regularly, one day they will start coming on time. It doesn't matter if they are running late; one has to be punctual in their daily routine. Initially, you may feel uncomfortable pointing it out repeatedly, but this is the only way to deal with latecomers.
Neelanjana
From India, Pune
Acknowledge(0)Amend(0)
Dear Viral,
Very nice format, only missing those who came late (late mark) in regular time. For example, 3 LM is a 0.5 deduction. This is useful for Corporate, for Production & factory need to update. Nice one.
Regards,
Pravin
HR
Acknowledge(0)Amend(0)
Very nice format, only missing those who came late (late mark) in regular time. For example, 3 LM is a 0.5 deduction. This is useful for Corporate, for Production & factory need to update. Nice one.
Regards,
Pravin
HR
Acknowledge(0)Amend(0)
Hi, It is very usefull but i think, you should showing sunday, this is perfect for daily attendence
From India, Ujjain
Acknowledge(0)Amend(0)
From India, Ujjain
Acknowledge(0)Amend(0)
Dear All, it is very helpful. i am attaching new format for daily attendance. pls go through the attachment & tell me how is it? Thanks & Regards Sachin Katkar
From India, Mumbai
Acknowledge(0)Amend(0)
From India, Mumbai
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.
Attendance sheet.xls