Prev: error -1.#IND
Next: search column for duplicate value during data entry
From: LABKHAND on 31 Mar 2010 13:42
Hi all,

I am trying to calculate the total number of working hours per each week (1
through 6) of a given year.

Here is the structure of my spreadsheet:

Row 1 contains a heading for each month of the given year.
Row 2 contains a heading for each week of month (week #1 through #6)
Row 3, I need a formula or VBA code that automatically inserts the total
number of available business working hours per that week. Of course
excluding the federal holidays which I have created a named range for it in
the spreadsheet.

for example for the target year 2010, I should have the following values in
each week of the month:

January-2010:
WK #1 - 0 hours (note: 1/1/10 is a holiday)
Wk #2 - 40 hours
WK #3 - 40 hours
WK #4 - 32 hours (note: 1/18/10 is a holiday)
WK #5 - 40 hours
WK #6 - 0 hours

February-2010:
WK #1 - 40 hours
Wk #2 - 40 hours
WK #3 - 32 hours
WK #4 - 40 hours
WK #5 - 0 hours
WK #6 - 0 hours

etc...for the remaining months.

I have tried many htings but I am nt able to get this working. Can any one
please help? Thanks very much.
From: Barb Reinhardt on 31 Mar 2010 14:15
Please show what you've tried so far.

Barb Reinhardt



"LABKHAND" wrote:

> Hi all,
>
> I am trying to calculate the total number of working hours per each week (1
> through 6) of a given year.
>
> Here is the structure of my spreadsheet:
>
> Row 1 contains a heading for each month of the given year.
> Row 2 contains a heading for each week of month (week #1 through #6)
> Row 3, I need a formula or VBA code that automatically inserts the total
> number of available business working hours per that week. Of course
> excluding the federal holidays which I have created a named range for it in
> the spreadsheet.
>
> for example for the target year 2010, I should have the following values in
> each week of the month:
>
> January-2010:
> WK #1 - 0 hours (note: 1/1/10 is a holiday)
> Wk #2 - 40 hours
> WK #3 - 40 hours
> WK #4 - 32 hours (note: 1/18/10 is a holiday)
> WK #5 - 40 hours
> WK #6 - 0 hours
>
> February-2010:
> WK #1 - 40 hours
> Wk #2 - 40 hours
> WK #3 - 32 hours
> WK #4 - 40 hours
> WK #5 - 0 hours
> WK #6 - 0 hours
>
> etc...for the remaining months.
>
> I have tried many htings but I am nt able to get this working. Can any one
> please help? Thanks very much.
 | 
Pages: 1
Prev: error -1.#IND
Next: search column for duplicate value during data entry