Back to ArticlesBack

Join 50,000+ PM Professionals

Get expert PM insights, PMP prep tips, and earn PDUs with exclusive content delivered weekly.

Protected by reCAPTCHA: Privacy & Terms

MPUG - Master Project User GroupMPUG

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.

Get Weekly PM Insights

Join 50,000+ PMs receiving updates on the latest PM methodologies, PDU opportunities, tool reviews, career tips, and member exclusives.

Protected by reCAPTCHA: Privacy & Terms

PMI ATP
PMI Authorized Training Partner
REP #4082

Learning Paths

PMP® TrainingCAPM® TrainingPgMP® TrainingPMI-ACP® TrainingMS ProjectMS PlannerMS TeamsJira

PM Resources

PDU TrackerLive WebinarsSalary CalculatorTool ComparisonsJob BoardKnowledge BasePM GlossaryOur Faculty

Community

Discussion ForumStudy GroupsEvents Calendar

Follow Us

LinkedInYouTubeTwitterFacebook
MPUGMaster Project User Group

© 2026 MPUG. All rights reserved.

TermsPrivacySitemapAdvertise
Articles

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 […]

1 min read
•about 11 years ago•Updated 10 months ago•
I
Ismet KocamanAuthor
Project Management
Microsoft Project
Best Practices
Productivity
I
Ismet Kocaman

Content Writer

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.

View all articles by Ismet Kocaman
Related Content

Continue Reading

Discover more insights and articles that complement your current reading

An Introduction to the PMI Practice Standard for Scheduling Conformance Index
Articles
1 min read

An Introduction to the PMI Practice Standard for Scheduling Conformance Index

Learn how the Conformance Index in PMI’s Practice Standard for Scheduling scores a CPM schedule model, and how to assess its components in any scheduling tool.

A
Anonymous
11 days ago
Read
A PM’s Halloween Survival Guide: The Sequel You Didn’t Want but Definitely Need
Articles
1 min read

A PM’s Halloween Survival Guide: The Sequel You Didn’t Want but Definitely Need

Part II of the PM Halloween survival guide takes on shape-shifting requirements and dependencies that won’t stay resolved, with practical defenses for each.

A
Anonymous
29 days ago
Read
Context Engineering for Project Managers: Give AI the Project, Not Just the Question
Articles
1 min read

Context Engineering for Project Managers: Give AI the Project, Not Just the Question

Learn how to choose, date, and source the project information you give AI, so its risk analyses, status reports, and change request reviews reflect your actual project.

A
Anonymous
about 1 month ago
Read
Explore All Articles