scheduling and hour tracking for multiple employees at multiple sites

I am trying to wrap my head around how I can set up a schedule and keep hitting walls. A little background, we provide a service of having inspectors at different locations during the summer months. Each location pays for a set number of hours and I put together a schedule. Last year we had around 20 inspectors and 6,500 hours at 21 locations. What I'd like to do is be able to change one person's schedule and have it linked to another sheet for tracking the hours. I don't really have an HR background so managing this many people has been a challenge for me. I have started a workbook with the first sheet having the date and inspectors in columns. The next sheet has dates and all of the locations listed for scheduled and actual hours. Finally each location will have it's own sheet for summing the actual hours by time of day. The inspectors won't work the same location every day and that's what I'm having trouble with. I basically need to know how many hours are scheduled so I can plan for the year, and need to know the actual hours worked because things change or come up for people. Maybe there is a better program out there to do this? I thought about trying MS Access but my experience is limited. Any help would be greatly appreciated.

For hour tracking and management of employees, we basically rely on the cloud based solution from Replicon. The hassle free experience of the same makes a better sense in terms of the time management which makes the process to go in a smooth manner. You can try out checking the same. Hope it will work out for you as well. Here is the link for your reference - http://www.replicon.com/time-tracking-softwares.aspx

I'll have to check that out. It may just be more cost effective/easier to use software designed for this.