SOS-Need to calculate number of working hours per each week of mon
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. |
SOS-Need to calculate number of working hours per each week of mon
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. |
SOS-Need to calculate number of working hours per each week of
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. |
All times are GMT +1. The time now is 07:52 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com