Attendance Report Format - over time Xls Download.. CiteOps
CiteOps
 
HOME RISE NEW ABOUT LOGIN
Home > Business & Services Market Area > Jobs Open Section

Attendance Report Format

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


Attached FilesProvided by community member sumeish. Join us to learn and grow with your peers.
File Type: xls attend updated.xls (284.0 KB, 3874 views)
kumar_viprla@vsnl.net - Member Since: Jun 2008
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

ranjit.kumar1@hdfcbank.co - 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

rajmohan

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

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



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






Explore Topical Knowledge Areas

Interesting Relevant Discussions


DISCUSSSION STATISTICS


9443
VIEWS

18
REPLIES

PLEASE KEEP YOUR CONDUCT PROFESSIONAL AND POLITE


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

Share »

Community Support & Professional Insights. Login or Register.
Email/Username     Password  

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