Add Time To A Date

[Danno4G94]

I have tried for a while on this, searched like crazy but have not had much luck, any help is appreciated. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
I have found another thread that has been quite helpful but does not quite address my needs.<o></o>
<o></o>
<o></o>
What I am looking for is a formula that can add hours from a start date and time that will give me an end date and time excluding weekends and holidays based on 24 hours per day working days 5 days a week (Monday to Friday)<o></o>
<o></o>
<o></o>
<o>This is what I have so far:
</o>A1 = Quantity of units (50,000)<o></o>
B1 = pcs/minute (90)<o></o>
C1 =A1/B1/60 (time needed for production run)<o></o>
D1 = Start Date & Time (09/03/10 01:00)<o></o>
E1 = =WORKDAY(D1,MOD(D1,1)+C1)+MOD(MOD(D1,1)+C1,1) (a formula I found that works for the weekday but not for the holidays)<o></o>
<o></o>
H2-H8 = Holidays ("Holidays" are defined)

I am using Excel 2007 and Windows XP

Thanks,
Dan

 

[Danno4G94]

Bump, can anyone help?

 

[Danno4G94]

TTT, I guess not.

 

[barry houdini]

Hello Dan,

You should just be able to add the holiday range as the 3rd argumet in WORKDAY, i.e.

=WORKDAY(D1,MOD(D1,1)+C1,H2:H8)+MOD(MOD(D1,1)+C1,1)