Start Date + Hours to produce end date & Time using Business Hours (AND include weekend)

Hi Guys,

I'm trying to get a formula that will enable me to start with a start date with time, then add a defined period h:mm to determine what the end date & time would be within business hours, but also include weekend as well (So 7 days).
Business Hours
Start 09:00
End 17:00

A2 = Start Date & Time e.g. 29/01/16 14:00
+
B2 = Hours e.g. 5:00
=
C2 = Formula to get to 30/01/16 11:00

Can anyone help me

Cheers

?? I don't understand. Do you want to count weekends or not? you're asking for both. Or do you mean that the start date could be on a weekend? Also given the example above, 14:00 plus 5:00 is 19:00. Do you want 9 AM Monday or two hours into Monday: 11 AM.

Hi dlfak,

Yes count weekends as well. So I could count business hours e.g. 09:00 till 17:00 Monday > Sunday.

But its okay now as I managed to work out a formula

Cheers

Hi Aardigspook,

I just did some further testing and it was only a part solution Ah well!

I currently have..
H3 = Start Time (09:00)
I3 = End Time (17:30

K5 = Date & Time e.g. (29/01/16 16:30)
L5 = Duration (2:00)

Formula
=IF(MOD(K5+L5,1)>$I$3,INT((K5+L5)+1)+(MOD((K5+L5),1)-$I$3+$H$3),(K5+L5))

Returns 30/01/16 10:00

However, if I go beyond 10 hours for duration it trips up so if as above I have the duration as 10:00 it returns 30/01/16 02:00 rather than 31/01/16 09:30

it obviously is the way I'm using the mods so I can't sum the number of days to add up. Will have to keep thinking.

Cheers

Thank you Jean.P28,

I had a look and (alot cleaner than my original attempt ) but I still have the same issue..

Thank you again for trying to help