formula to calculate the date and time within the business hours by Adding hours and excluding Holidays weekends

[Anand21sam]

formula to calculate the date and time within the business hours by Adding hours and excluding Holidays weekends
Any Help

 

[Anand21sam]

i am using Formula (WORKDAY.INTL(StartDate,CEILING((HourstoAdd /24+MOD(StartDate,1)-$BusinessHrsStart)/(BusinessHrsEnd-BusinessHrsStart),1),11,Holiday_List)+MOD(StartDate,1)+HourstoAdd-CEILING(MOD(StartDate,1)+HourstoAdd-$BusinessHrsStart,$BusinessHrsEnd-$BusinessHrsStart)+$BusinessHrsEnd-$BusinessHrsStart,"")

This Formula is working fine untill with time but adding Day+1 and Also when the Start time is not Post BusinessHrsEnd it is adding it to time ++

i.e if
BusinessHrsStart 10:00:00 am

BusinessHrsEnd 6:00:00 pm

if Start time is > 6:00:00 pm it addes the Day+1 which is ok but it also addes the Time ++

where i want if the Start time is > 6:00:00 pm then Hours Calculation should be (BusinessHrsStart+ HourstoAdd) ..


Any Help..............