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

Hi Andy,

Here's a simple way that will do it. What I did is to format your time columns in accordance to the excel format and did a simple subtraction to calculate the no of hours spent.

It certainly is not the best way, but at least it will be able to work.

Cheers,
J

try use this

=(B9-A9)*24

Hi jtan,

Thats perfect! Thank you very much for looking at this for me.

sglife; I tried doing something along those lines, but it must have been the format I was entering my times. Excel didn't recognize it.

Thanks to the quick responses.
Andy