Maintain Attendance Record Of Your Organisation In Excel

deepak_dwivedi9
Dear friends,
Please find attached an Excel Sheet, which may be useful to track the attendance of your Empoyees and other related details..e.g. PL, CL, SL etc...
I am working on this to make it as a software/Application, where we will be required to click the feeded entries to track the records and more.......
Take Care....
1 Attachment(s) [Login To View]

virurids
The best I have seen for such records.
1 Attachment(s) [Login To View]

deepak_dwivedi9
Thanks for this....
But is it shareable ?? as this contains a name of Company. Please confirm back if it's copyright material and may be illegal to use as we try to share those documents, which is personally developed or is shareware...
take care...
virurids
Dear Deepak,
Sorry for the delay in reply.
It's free template form Microsoft. you can share it!! don't worry!!
digs123
Dear All,
I have attached an Excel template for attendance and formula based salary calculation. You can surely modify it as per your requirement. Its ideal for small enterprises. Let me know you feed back, suggestions and comments. :idea:
Regards
Digant Dagha
1 Attachment(s) [Login To View]

swapnasangari1
Hi deepak,
You might want to use this attendance sheet along. I think it should fit to your requirements.
thanks
Swapna
1 Attachment(s) [Login To View]

krndep
All of the above sheet are very well implemented. But I am in need of a Break Tracker sheet for my organization. This tracker should give me output in Minutes/hours the employee has spent on his workstation. Which can be done as (Time IN) Less Number of breaks (Time Out). I don't know how to implement this in excel. Can Anyone Help Me. Thanks!! KARAN.. [Login to view]
manoharan_rk
Dear Ms.Swapna,
Please accept my sincere thanks for making this attendance template available. I was breaking my head for making a template of similar sort, yours was absolutely wonderful.
Good Day
RK Manoharan
Chennai
:icon1:
mjj21
Leave card format is exceptionally great for small enterprise. many thanks to the uploader...and a big thank you for all the other great templates...really made my day... :)
vishwanathsavula
Hi all,
can any please let me know the formula to leave card (attached in this thread) change the colour in the total leaves used coloumns. in my compnay we have 12 CL, 12 SLs, 15 ELs. But the CL column changing its colour if the leaves are more than 6 days. I would like to change it to 12 days. Please help me.
If you are knowledgeable about any fact, resource or experience related to this topic - please add your views. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone. Join To Contribute