Help with NETWORKDAYS

[KenG]

I know this shouldn't be this difficult but I am having a hard time working out a formula for this. I'm trying to keep a running total of time where I have the known of start date and an activity with a known time to complete. I want to be able to keep track of date and time for the end of each activity or a sequence of activities while staying within the parameters of a five day work week and an 8:am-5m work day. I hope I made sense here and any help would be appreciated.

Ken

 

[Jerry Sullivan]

Welcome to the Board,

It's not exactly clear to me what you want this to look like.

This thread might get you pointed in the right direction.
http://www.mrexcel.com/forum/showthread.php?t=562643

If this doesn't answer your question, try to mock up what you want the worksheet to look like and post a small screenshot.