Convert Hours to Workdays, Excluding Holidays

[mycon73]

Hi,

I wish to convert total hours to workdays, excluding weekends & holidays. Currently, I have the following:


=((F11-INT(F11))*24)/8

F11 = 1920 Hours

How do I modify or utilize another function that calculate (40 Hr.) workweek & exclude holidays?


Thanks

[Fotis1991]

Hi

How do you get the result in F11?

Which is the start day and which is the end date?

Can you explain a little more?

[mycon73]

Hi Fortis1991,

The result from Cell F11 is the calculated duration of 80 items, which take approximately 24 hrs. each to work through -- 80 x 24 = 1920

Now, I also wish to present this as workdays - excluding weekends & holidays.

Thanks

[Fotis1991]

Perhaps my reasoning is wrong, but so I understand the issue.....

This is only for workdays. I can not thing anything that will calulate the holidays if we don't know the start and the end day for these 1920 hours.


1920/8 hours=240 Days
240/7 days/week=34,29 Weeks
34,29*5 workdays/per week.=171,423 Workdays

=((F11/8)/7)*5

[mycon73]

Hi Fortis1991,

This is not the result that I expecting. I didn't provide this before, but I'm planning a project that is suppose to be worked between 08/20/12 thru 12/21/12 & using a networday function, I get 87 days or approx. 18 weeks.

With this 1920 result, I am trying to forecast how many deliverables per week would be required ot meet our target date, as well as to determine the number of workers needed to work these deliverables.

For the most part, I'm breaking down my analysis in hours but for MS Project, I'm utilizing days. If 1920 equals 171 days, then that's probably the correct result. It just means I need to put more resources on the tasks.

Thanks