Ok....i need more excel help.

In my file I have a sheet for every month. In each month I have each day outlined:

1-Aug

2-Aug

3-Aug

etc.

If each work day is comprised of 8 hours (including a one hour lunch) how do I total the number of total hours in a given month that a person is required to work? Does anyone know that formula? The dates are in column C (starting at row 4) but there are blank rows in between. Here is an example of my sheet

time sheet.jpg

So 8 hour days and in the month 18 work days in the month. How do I get Excel to tally that without me having to do it manually for every sheet I create?

Thanks for any help!!

In my file I have a sheet for every month. In each month I have each day outlined:

1-Aug

2-Aug

3-Aug

etc.

If each work day is comprised of 8 hours (including a one hour lunch) how do I total the number of total hours in a given month that a person is required to work? Does anyone know that formula? The dates are in column C (starting at row 4) but there are blank rows in between. Here is an example of my sheet

time sheet.jpg

So 8 hour days and in the month 18 work days in the month. How do I get Excel to tally that without me having to do it manually for every sheet I create?

Thanks for any help!!

## Comment