sumeish Started The Discussion:
I’ve attached attendance report format for you guys. This format will help you to track the attendance daily, weekly and monthly. The best part is, in this format you can find first week report in the Sheet-1 and second week report in the Sheet-2 and so on… and on the last Sheet you can find the Month End Report automatically updated. All are formula based.. so you don’t have to do any thing…you just have to fill in the week days as given below.
For present = “P”
For absent= “A”
For Leave= “L”
For Off= “Off”.
Just update the First Sheet with Employee Name, Employee Id, Designation, and Department… and the rest of the sheet will be update automatically.
Hope this format was helpful for you. Kindly comment with your feedback.
Many thanks…and have a rocking day…
Dear Mr. Sumesh,
I've newly joined into this group and i would like to appreciate your hard work but a small clarification, since most of the companies use the software's to update the attendance, but in my company we use excel to calculate even time...so kindly let me know how do you calculate timings since our off timings is from 9:30 to 18:30.
Awaiting your reply at the earliest.
Found This Useful? +Vote Up This Page Via Google.
Why Vote? User validation is extremely important for good content to prosper.
Disclaimer: This network and the advice provided in good faith by our members only facilitates as a direction towards the actions necessary. The advice should be validated by proper consultation with a certified professional. The network or the members providing advice cannot be held liable for any consequences, under any circumstances.
Explore Topical Knowledge Areas
Topic Categories >> attendance sheet leave management excel leave management system audit attendance format attendance report Location-India-Hyderabad Complete List Of Categories
Interesting Relevant Discussions