Timesheet to calculate No Hours?

Hi Everyone,

I am very new to Excel, and I am trying to set up a simple timesheet for the company. We are a small drafting office, and mainly just need to see what jobs the draftees have been working on, and for how long.

Attached file Timesheet_Template_rev2.xls is what I have set up now, and we are currently using.

What I would like to do, is add another column with No Hours spent, and then make a function at the bottom of each week, which totals No Hours for that week.

I think the easiest method is to nominate the bottom line of each day to show lunch break start & finish time. This will not be part of the calculated hours.

Please see the other attachment Timesheet_Template_rev3.xls. This is where I hit my stumbling block. When I put in the function for No Hours for each task, it does not work. I am thinking it has to do with the predetermined "list" for times.

Any suggestions on how to get this to work, or if you have a better idea on how to set this sheet up, will be very much appreciated.

Kind regards,
Andy