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
Posted 5th August 2008 From India , Hyderabad
Attached Files
Shared By Cite.Community Member "sumeish" For Public Download
File Type: xls attend updated.xls (284.0 KB, 4762 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
Posted 24th September 2008 From India , New Delhi
Hi, I think this format will help the organisation to audit the manpower and performance of manpower. So its realy good . Ranjit
Posted 6th October 2008 From India , Mumbai
Hi, Santhosh I think this is an excellent format . Hi Sumesh Subramanian T:mrgreen:his is an excellent:ph34r: format .
Posted 25th November 2008 From India , Bangalore
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.
Posted 26th February 2009 From India , Madras
Thanks a lots..its very useful for me as just now i have started work on this for my company. regards Sulipsa:-)
Posted 24th March 2009 From United States , Franklin
Hi Sumesh..... Its a nice tracking mechanism.... Thanks for sharing with us.... You are Rocking Man... Rgds, Chandrakanth A G
Posted 26th March 2009 From India , Madras
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.

Posted 4th June 2009 From India , Bangalore
Hi Sumesh, Excellent. I appreciate your Technic used for this and congratuations. I wish you all the best of luck. Regards, Shree
Posted 22nd June 2009 From India , Mumbai
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
Posted 7th July 2009 From Malaysia , Kuala Lumpur

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.

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+  
Privacy Policy | Disclaimer | Terms Of Service
Facebook Page | Follow Us On Twitter | Linkedin Network