Excel 2007 : Creating a time table from 8 to 8

Hi,

I would like to create a workbook with a timetable, similar to the example files attached.

1 Sheet per Date option - Conditional Formatting/Arrow shapes
I want Excel to create one worksheet per date (I can create those manually first if need be) in the given month with column A having the labels in 1 hour intervals from 8:00am to 8:00am the next day.

Then, it needs to setup the data as per the May31st sheet in ExampleTimeSheet. It then needs to draw arrows or otherwise color the cells to mark that someone was present between the In and Out times.


Charting option - Using graphs
The alternative is to use charts.
I have provided an example chart in the TimeTable file on how that chart would look like and be generated and it would need to create 1 chart per date and update the range on the chart accordingly.



Weekends
I don't need the charts/sheets for days which are weekends, i.e. Saturday and Sunday, but keep them in if it makes it easier.

Much appreciate any help and pointers you can offer! Your contribution may save some nursing jobs at the local hospital

[Edit 4]
Cleaned up the thread and the attachments