Loading...
Quick Links

Filter for Tasks Taking Place Outside of 8 to 5

If you want to identify which tasks don’t start at 8 a.m. and don’t finish at 5 p.m., here’s how:

Enter the following formula to a custom flag field, for example, Flag1, and then filter for tasks whose Flag1 field doesn’t display Yes:

Format( [Start], “hh:nn AMPM” ) & ” ” & Format( [Finish], “hh:nn AMPM” )
Like “08:00 AM 05:00 PM”

The filter will also work for manually-scheduled tasks whose Start and Finish fields contain valid dates.

Ismet Kocaman
Written by Ismet Kocaman

Ismet Kocaman, MCTS, PMP, is a Mechanical Engineer based in Turkey. He has more than 15 years of project management experience in the manufacturing sector. He currently provides consultancy to small to mid-sized companies on project management, reorganizing, and streamlining the manufacturing operations. He also conducts training seminars for engineers on MS Project. Contact Ismet at ikocaman.pm@gmail.com.

Share This Post
1 Comment
  1. Ismet Kocaman

    Do not copy/paste the formula, instead enter it by typing in.
    “nn” in the format string represents minutes.

    Reply

Leave a Reply

Your email address will not be published.

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Please complete this equation so we know you’re not a robot. *

Thanks for submitting your comment!
You must be logged in to comment.