Adding "cycle time hours" to a start date within business hours to determine Finish date / time.

[coltsfan]

Hello everyone,

I am looking for help figuring out this formula or a VBA to paste.

I am building a scheduling tool and would like to add the "cycle time" calculated to the start date / time but only to count within business hours.

For example:

Business hours from 9 am to 5 pm, 1 hour lunch.

Start: March 20th 2014 09:00 AM

Process will take 11 hours to complete.

End date: (Where i need help) : I need a formula to add the 11 hours to the start date only counting business hours. After 5 pm, add the remaining hours to next day 9 am onwards.

Any help / suggestions would be greatly appreciated.

Thanks