2/13/2015 8:02 AM
To track labor hours we have a computer located in the break-room. Using Microsoft Access, I created a series of forms that the employees fill out as they complete their daily tasks, fuel usage and so on. The information can then be filtered and totaled as required. There's a little bit of time involved for the initial setup but after that it requires very little time maintaining it. There are a series of drop down lists that the employees choose to complete the forms. very little typing required on their part.
We've been using this system for over ten years and have recorded tens of thousands of daily employee tasks and their hours and wages for those tasks.
[attachment=1">employee-log.jpg[/attachment">
[attachment=0">log-table.jpg[/attachment">
You could do the same thing with Google docs and create a series of forms for the employees to fill out as they complete their tasks. Very similar to Microsoft Access but with less capabilities.
We also track our labor hours using Excel for payroll purposes but it does not associate tasks with hours. Just total hours for the payroll period.
Works for us.