I'm exploring options to keep track of multiple employees on the same computer network working at various locations using a shared master excel spreadsheet that will update periodically by accessing timecard spreadsheets on employees computers. This maybe an impossible project, but it would seem possible with the limited knowledge I have of shared worksheets.
Ideally, a timecard spreadsheet would be kept on the employees computer. It would be password protected so only the employee could access the spreadsheet. It would be referenced in the master spreadsheet and periodically the master spreadsheet would poll the employee timecard spreadsheet to gather the time data necessary for payroll processing and management purposes.
The timecard spreadsheet would capture the time the employee makes the entry reflecting his/her in and out times in the spreadsheet. Employees would be instructed to record their times in and out as a first priority and the entry capture time would be compared and reported in the master spreadsheet. Significant differences between the time reported in and the data capture time would be reported in the master spreadsheet and reviewed by management for inconsistencies.
This would bring consistency to the time recording process for our organization and I would imagine it would have a broad application across many businesses. We are presently having employees write down their time and turn it in to their supervisors on paper submitted one time monthly...which is a very poor way to handle such a sensitive and critical aspect of our organizations resources.
Thanks in advance for your helpful comments!!!
NJ Will
Ideally, a timecard spreadsheet would be kept on the employees computer. It would be password protected so only the employee could access the spreadsheet. It would be referenced in the master spreadsheet and periodically the master spreadsheet would poll the employee timecard spreadsheet to gather the time data necessary for payroll processing and management purposes.
The timecard spreadsheet would capture the time the employee makes the entry reflecting his/her in and out times in the spreadsheet. Employees would be instructed to record their times in and out as a first priority and the entry capture time would be compared and reported in the master spreadsheet. Significant differences between the time reported in and the data capture time would be reported in the master spreadsheet and reviewed by management for inconsistencies.
This would bring consistency to the time recording process for our organization and I would imagine it would have a broad application across many businesses. We are presently having employees write down their time and turn it in to their supervisors on paper submitted one time monthly...which is a very poor way to handle such a sensitive and critical aspect of our organizations resources.
Thanks in advance for your helpful comments!!!
NJ Will
