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…
Regards
Sumesh Subramanian
5th August 2008 From India , Hyderabad
Attached Files
File Type: xls attend updated.xls (284.0 KB, 4765 views)

Thanks
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
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
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 .
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
rajmohan
Thanks in advance.
26th February 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 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.
Regards,
Sapna
4th June 2009 From India , Bangalore
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
7th July 2009 From Malaysia , Kuala Lumpur
Monitor live - entire attendance of your company staff from your office/home
Manual records always have chance of error. Thre is a a very good product on Attendance & Leave management system. Its is a web based product. It gives you a live report on the Time, Attendance and Leave of the entire organization across any number of branches. It has facility of individual employee logins, interactive tool for leave sanctioning between employee to reporting heads, sms system for employee on field etc.
You can send your enquiries to
Regards,
JP

2nd March 2010 From India , Mumbai
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=
rajmohan
Thanks in advance.
10th April 2010 From India , Hyderabad
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=
Prasanth
Thanks in advance.
Reply With Quote
10th April 2010 From India , Hyderabad


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