Attendance Report Format - over time Xls Download.. CiteOps

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. Join us to learn and grow with your peers.
File Type: xls attend updated.xls (284.0 KB, 4133 views) -  Member Since: Jun 2008

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 -  Member Since: Sep 2008
Hi, I think this format will help the organisation to audit the manpower and performance of manpower. So its realy good . Ranjit

Anumod KM -  Member Since: Nov 2008
Hi, Santhosh I think this is an excellent format . Hi Sumesh Subramanian T:mrgreen:his is an excellent:ph34r: format .

raj1371 -  Member Since: Jan 2009
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.

sulipsa -  Member Since: Oct 2008
Thanks a lots..its very useful for me as just now i have started work on this for my company. regards Sulipsa:-)

jeyvichand -  Member Since: Feb 2008
Hi Sumesh..... Its a nice tracking mechanism.... Thanks for sharing with us.... You are Rocking Man... Rgds, Chandrakanth A G

asapna -  Member Since: Jun 2009
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.


Cheekujois -  Member Since: Nov 2008
Hi Sumesh, Excellent. I appreciate your Technic used for this and congratuations. I wish you all the best of luck. Regards, Shree

shejrswe -  Member Since: Jul 2009
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


  • Do not post anything derogatory about any company or person.
  • Sharing articles from other websites should be done by posting a link to the original article.
  • To discuss sensitive issues create a pseudo/anonymous account.
  • Please avoid repeat posting your company profile - such accounts are removed automatically.

  • 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.

    Cite.Co helps people come together to solve each other's problems on all aspects of professional life.
    Share This Discussion:

    3M Users, 100K+ Documents & 450K+ Discussions

    About Us - Advertise - Contact Us - RSS   On Google+  
    All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
    Privacy Policy | Disclaimer | Terms Of Service
    Facebook Page | Follow Us On Twitter | Linkedin Network