Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Schedule tasks to avoid them extending over non-working time.

Posted on 2010-01-12
Medium Priority
Last Modified: 2013-11-15
I'm working on a scheduling system for the company that I work for. It was decided that Project 2007 was the best solution for our needs however there is one slight niggle that keeps getting in my way.

The problem is some of the tasks I need to schedule must begin and end in the same (continuous) working block. They must not span say a non-working weekend. Is there any way of telling Project that once this task has started it can't be stopped until it has completed and must not enter or extened over a non-working block.

An example follows:

Working periods (09:00 - 12:00, 13:00 - 17:00), Each task has a duration on 1 hour. First task begins at 09:30, second at 10:30. The third not start until 13:00 as it can't enter the non-working period of 12:00 - 13:00 however Project would start to task at 11:30 and complete it at 13:30.

Thanks in advance for your help,

Ashley Bissell.
Question by:hiddenshadow
  • 2
LVL 12

Accepted Solution

Dr. Thomas Henkelmann earned 1500 total points
ID: 26302478

does this mean you don't have any tasks that take longer than 4 hours as they won't fit anywhere? And you are linking them to calculate the schedule, right?
I don't know of any options that force a task to NOT run across a non-working time. This can be done with a macro that checks for the tasks start and finish date vs the duration, then looks for the beginning of the next working period and constraints the task to only start then.



Author Comment

ID: 26303745
Thanks for your response Thomas.

All of the tasks will be able to fit within a "working" time period and should never be large enough to not fit within a "working" time slot. I had thought of a macro that did this but I ws hoping there was a slim glimmer of hope that Project might have a function that allowed this. I can understand why it doesn't but it would make my life easier :).

I will leave the question open a little longer incase anyone else has any ideas. If not I will award the points to you.

Author Closing Comment

ID: 31675993
Thomas I agree that this is the best/only solution and I'm thus awarding you the points.

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Online collaboration is quickly becoming embedded in the workplace, and its benefits are tangible. See what the current landscape looks like and what the future holds for collaboration tools and the future of work.
"Disruption" is the most feared word for C-level executives these days. They agonize over their industry being disturbed by another player - most likely by startups.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…
Suggested Courses

572 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question