Maintain Attendance Record Of Your Organisation In Excel - CiteHR
Vishwanathsavula
Human Resources
Virurids
Student
Swapnasangari1
Manager-hr
KARTHICPS
Accounts Officer / Manager
+8 Others

Cite.Co is a repository of information created by your industry peers and experienced seniors sharing their experience and insights.
Join Us and help by adding your inputs. Contributions From Other Members Follow Below...
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....

Attached Files
Membership is required for download. Create An Account First
File Type: xls Attendance Sheet.xls (16.5 KB, 31654 views)

Community Prime Sponsors
FactoHR.com - Payroll Software with GPS Enabled Attendance, Travel, Performance Management, HRMS.
Talentedge.com "Interactive Anywhere Learning". Executive courses from top reputed institutes like IIM, XLRI, MICA.
The best I have seen for such records.

Attached Files
Membership is required for download. Create An Account First
File Type: xls leave card.xls (44.0 KB, 9157 views)

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...
Dear Deepak, Sorry for the delay in reply. It’s free template form Microsoft. you can share it!! don’t worry!!
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

Attached Files
Membership is required for download. Create An Account First
File Type: xls Attendance-September-monthly.xls (25.5 KB, 9737 views)

Hi deepak, You might want to use this attendance sheet along. I think it should fit to your requirements. thanks Swapna

Attached Files
Membership is required for download. Create An Account First
File Type: xls Copy of Attendance_Sept_08.xls (101.5 KB, 6040 views)

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

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

Please Login To Add Reply






About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service



All rights reserved @ 2019 Cite.Co™