Excel 2013 : Time sheet kinda thing :P

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

i'm not that good at excel :D just a idea I came up with, i'm still reading around trying to figure out how to do it..so I have basically nothing done yet ahha

I thought for someone who knew Excel, that this might not be that hard to do, not knowing excel to well

I decided to post a thread here hoping i'd get feedback / help / suggestions / possible solutions for what I require...so in a way I am stuck, or I wouldn't have posted here

wow :D that's awesome popipipo :D

Ok, So I basically got what I want, but have a few little issues..

when I add up the TH Week (Cell A05 - A024) as soon as it goes over 24 hours, it resets to 0 and I want it to give me the total hours worked for each day that user works.

any suggestions on how i'd fix that ?

I've attached the document..I've made issues red ehe

excellent :D fixed, thanks popipipo :D