I need an Excel sheet that I can use on the main computer in the company. Every employee should be able to come in, enter their ID and password, and click "push in." The Excel sheet should automatically record their entry time. When they want to leave, they should enter their ID and password again and click "push out," and the Excel sheet should automatically record their exit time. This process should apply to all employees.
Notes: The time should be calculated per hour. I should be able to search and find the records of each employee for a month.
From Palestinian Territory, Gaza
Acknowledge(0)
Amend(0)
Notes: The time should be calculated per hour. I should be able to search and find the records of each employee for a month.
From Palestinian Territory, Gaza
Acknowledge(0)Amend(0)
Its short term soln..and have compliance issues..better develop or go for HRIS application...in market there are various HR application ..which add value to HR activities..
From India, Hyderabad
Acknowledge(0)Amend(0)
24From India, Hyderabad
Acknowledge(0)Amend(0)
Greetings,
In addition to what White Eagle has suggested, please consider reading the following posts on how to build an MIS. You would need to hire an external consultant or an agency that can map all your requirements and offer you the best solution. The discussions and formats shared here are for your reference.
[How to make an MIS](https://www.citehr.com/66182-mis-report-formats-excel.html#post280780)
[MIS - Excel Sheet](https://www.citehr.com/266778-mis.html#post1195182)
Alternatively, you may consider starting to put the information available for the employee in a definite pattern so that it can be accessed by everyone who may need it. The problem with such an internal effort is that it remains a patchwork. Please consider a solution in totality. You may share the areas that you find difficult for us to further brainstorm.
Thank you.
From India, Mumbai
Acknowledge(0)Amend(0)
In addition to what White Eagle has suggested, please consider reading the following posts on how to build an MIS. You would need to hire an external consultant or an agency that can map all your requirements and offer you the best solution. The discussions and formats shared here are for your reference.
[How to make an MIS](https://www.citehr.com/66182-mis-report-formats-excel.html#post280780)
[MIS - Excel Sheet](https://www.citehr.com/266778-mis.html#post1195182)
Alternatively, you may consider starting to put the information available for the employee in a definite pattern so that it can be accessed by everyone who may need it. The problem with such an internal effort is that it remains a patchwork. Please consider a solution in totality. You may share the areas that you find difficult for us to further brainstorm.
Thank you.
From India, Mumbai
Acknowledge(0)Amend(0)
This XLS business won't work out as you wish. Maybe for 10 people, this may work.
A spreadsheet is a good tool for individual administration and not the ultimate tool for MIS. It's better to explore some good tools to manage data in your organization.
From India, Bangalore
Acknowledge(0)Amend(0)
A spreadsheet is a good tool for individual administration and not the ultimate tool for MIS. It's better to explore some good tools to manage data in your organization.
From India, Bangalore
Acknowledge(0)Amend(0)Looking for something specific? - Join & Be Part Of Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.