Hi,

My company work with individuals with disabilities. We have some problems internally with our timesheet/billing system, and I am thinking that we could use Excel to help solve these problems. Here is a description of our current system and the problems:

We have about 30 workers and about 130 clients. Each worker's timesheet has 15 minute increments, the client's last name, type of service, and then number of hours worked. This is currently done on paper. Then, the worker fills out an attendance sheet (on paper) with each client's name, and the amount of time worked with that client each day of the month. Then, our office manager collects these attendance sheets and enters the amount of time worked with each client per day into an Excel spreadsheet (each client may have more than one person work with them in the course of the month). This spreadsheet is used to bill the agencies paying us for our work with the clients.

Often times, worker's timesheets do not match the attendance sheets. There are many things that cause these errors, and our auditors want us to fix these problems. I think the best way would be to have the timesheets completed on Excel, and have these automatically populate the final attendance on an Excel spreadsheet.

So, the first question is the best way to create an Excel timesheet where start and end times for each client can be entered, and then the number of hours with each client is automatically calculated. I may be able to figure this out on my own, but any ideas of how to do this or resources where I can learn this best way to do this would be greatly appreciated.

The second question is how can we get these daily timesheets to automatically populate our final attendance spreadsheet. Each worker's timesheet will need to be linked to the final attendance spreadsheet. We have about 30 workers and about 130 clients.

We are working on Excel 2007.

Is it reasonable to ask for help with a problem like this? Is there anything more that I should provide? This is my first post to the forum.

Thank you.