Hi, I'm creating a production planning schedule. I'm attempting to have it so i input a start date and have excel calculate a finish time.
so here is where i become stuck. I can't seem to figure out how to set it up so it only counts working times as apposed to 24/7.

for example if i input a start time of 19/01/2016 10:00:00 and i add 30 hours, i would need it to return 22/01/2016 13:00:00. Not 20/01/2016 16:00:00. (providing I've worked that out correctly)

so working based around a 9 hour day 8 am to 5 pm Monday to Friday.

does anyone have any ideas, is it even possible?

I hope this is clear enough, it's my first post so i apologize if it isn't. please ask for more details if necessary.

Thank you.