sumeish Started The Discussion:
Hi All,
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…
Sumesh Subramanian
Attached FilesProvided by community member sumeish. Register to join your network of peers.
File Type: xls attend updated.xls (284.0 KB, 4718 views)

Very good and sencitive work.

I want to clarrification the following things

If use your attendence file format benefit for 8 hrs working duration .Suppose some organization giving over time,so how will adopt your file format.

Can explain its
Hi, I think this format will help the organisation to audit the manpower and performance of manpower. So its realy good . Ranjit
Hi, Santhosh I think this is an excellent format . Hi Sumesh Subramanian T:mrgreen:his is an excellent:ph34r: format .
Hi Sumesh,

Can you send the excel attendance sheet to my email id because when i open your sheet from this website I am unable to open it gives me an error message saying "file corrupt" so please resend the excel sheet to my email id


Thanks in advance.
Thanks a lots..its very useful for me as just now i have started work on this for my company. regards Sulipsa:-)
Hi Sumesh..... Its a nice tracking mechanism.... Thanks for sharing with us.... You are Rocking Man... Rgds, Chandrakanth A G
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 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.

Hi Sumesh, Excellent. I appreciate your Technic used for this and congratuations. I wish you all the best of luck. Regards, Shree
it’s amazing..but i’m truely not an IT and formula person..if i wanna use as is total no of hrs worked? how do i then modify

This discussion thread is closed. If you want to continue this discussion or have a follow up question, please post it on the network. Add the url of this thread if you want to cite this discussion.
Found This Useful? +Vote Up This 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.

About Us - Advertise - Contact Us - RSS   On Google+  
Copyright © 2016 Cite.Communities (CiteOps.Com) User contributions are owned by the contributor.
Privacy Policy | Disclaimer | Terms Of Service
Facebook Page | Follow Us On Twitter | Linkedin Network