Prev: VBA Input box (or MsgBox) with pull down or choices
Next: using Forms and VBA within Excel
From: LABKHAND on 31 Mar 2010 14:34
Barb,

I am not sure where to start...I have even confused myself since I keep on
trying different things. TO be honest, I am not sure where to begin to tell
you what I have tried. Sorry!

"Barb Reinhardt" wrote:

> 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: VBA Input box (or MsgBox) with pull down or choices
Next: using Forms and VBA within Excel