Basically we are wanting a solution that we can used to schedule our employees. The center manager would go online to this website. From there they will see all of their employees which should be automatically pulled from active directory by location. From there they will see the current days of the week, Monday - Sunday. Below that there will be an IN / OUT time for the employee. There will be a weekly total of hours for each employee and a daily total of hours for all employees. The daily total will be compared to our allowed hours based on another query of a [url removed, login to view] the attached sample.
I would like for each week to have the data stored so the manager could go back and look at it and schedule into the future. We can tweak it as needed.