Calculating YTD to End-of-Year Hours

[mycon73]

Hi,

I am creating a template to calculate total available hours from current date or week until the end of the year or during a specified project duration.

I would like to do 3 things, as follow:

1) Total available normal work hours, minus holidays - Shown in column J in my example template
2) Year-to-date (YTD) available normal work hours between current date or work week until the end of year - Column L
3) Available Project Hours during specified project duration - Column N

All calc to exclude specified holidays.

I started this function in Cell J10 for the first week of the year - January 1st to January 8th:

=IF(B10>=Holidays_2013,IF(F10<=Holidays_2013,(40-Holidays_2013),40))

My result is 40 hours when it should be 32 hours because New Year's Day was not worked.

Please assist with providing functions.

Thanks

[etaf]

you have in B10 - February - not the 1st of Jan and then ends on 7/2

so friday to thursday

you can use
=NETWORKDAYS(B10, F10, Q10:Q19 )
will give you the number of workdays - if a standard 8 hour day * 5

Q10:Q19 are the holidays

change B10 to
1/1/13 and it calculates as 4 days
* 8
=32

[mycon73]

Hi etaf & Others,

Isn't there a way to the week-to-week duration or start date (Monday's) to end date (Sunday's), then conduct a vlookup function & subtract 8 hours from the standard 40 hour week?

What would the function look like to to this?

Thanks

[mycon73]

Hi,

Please- Can anyone assist?

Thanks