Hey all, i'm looking at creating a spreadsheet like the following, but done automatically - would be great if it can be used in excel 2003 / 2007 as well

excel.jpg

What I want out of it :

User - Manual input of names
Start Time - Drop Down Box or Number of start time
Finish Time - Drop Down Box or Number of finish time
8am - 4pm - Boxes Change Automatically to yellow depending on Start / Finish Times which were input
Total Hours - Total Hours worked


any help would be grateful
Casey