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.
Regards
From India, Pune
Regards
From India, Pune
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
Thanks,
Srinivas
From India, Hyderabad
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
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
Hi, It is very usefull but i think, you should showing sunday, this is perfect for daily attendence
From India, Ujjain
From India, Ujjain
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
From India, Mumbai
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.