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.

Avatar photo
Written by Ismet Kocaman
Ismet Kocaman, MCTS, PMP, is a Mechanical Engineer and 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. Avatar photo

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

Leave a Reply