Can this be done?

[Merlin]

I have a 1500 activity shutdown schedule and management wants to see a gant
chart for only activities that will be taking place at 8:00 AM. Can this be
done without resource loading the project?

There are too many activities and not enough time to code each one
individually.

 

[davegb]

I have a 1500 activity shutdown schedule and management wants to see a gant
chart for only activities that will be taking place at 8:00 AM. Can this be
done without resource loading the project?

There are too many activities and not enough time to code each one
individually.

I don't have Project here to try this, and have never done it. But try
filtering the Start Date field for "=8:00am" and see what happens.

Hope this helps in your world.

 

[Gérard Ducouret]

Merlin,

I'm not sure of what you want, but try to insert a custom field such as
Number1 (Insert / Column...), and copy this simple formula:
Hour([Start])
Then create a filter (or activate an automatic filter) which will test on
the value 8.
Hope this helps,

Gérard Ducouret

 

[JulieS]

Hi Merlin,

Do you only want to see tasks that start at 8:00 am on any day or a
specific day?

If you want to see tasks that start on a specific day at 8:00 am you
could create a custom filter (Project> Filtered for> New). Set the
filter criteria to:
Field: Start
Test: Equals
Value: "Enter in the date and time"?

[Note: enter the value prompt exactly as shown with the quotes and
question mark]

This will create a dialog box that pops up when the filter is run. Be
sure to enter in the full date and time information. That will show
only tasks with that exact start date and time.

If you want to see tasks which only begin at 8:00 on any date, you'd
have to do a bit more manipulation to be able to extract just the time
portion of a start or finish date.

In quick testing I was able to pull out just the time portion of a date
field using the following formula in a text field:

Hour([Start]) & ":" & Minute([Start])

Then a quick autofilter allowed me to just view any task with the
seleted start time.

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project

 

[Merlin]

Julie S,

Thanks for your response. My problem is that I need activities that either
start at or are in progress at 8:00 AM. For instance an activity may have a
two hour duration and starts at 7:00. I will need this activity to show on
the gant chart.
I have used autofilter for activities greater than or equal to 7:00AM and
less than or 9:00AM, but it misses some activities that started ealier and
span past 8:00AM.

Thanks,

Merlin

 

[Mike Glen]

Hi Merlin,

Have you tried Project/Filtered for...../More filters.../In Progress Tasks?

Mike Glen
Project MVP

 

[Steve House]

First big thing to decide is whether "taking place at 8am" means the task
STARTS at 8am or is UNDERWAY at 8am, having started at 8 or earlier.
Secondly, is this 8am on a specific day or 8am on any day?

 

[Merlin]

Lets say I have a hundred task that begin at various times from 12:01AM March
28th thru 8AM March 28th. These task have varying durations from 12 hrs to 1
hr. I need to report to management all activities that will be taking place
during the 8:00AM hour. Some of the activities that started before 8:00AM
will be completed and not on the report while others are still in progress or
begining at 8:00 AM and will need to be on the report.

This schedule is not fully resource loaded so I cannot use work as a
reporting tool. I can only use the Gantt Chart.

 

[JulieS]

Hi Merlin,

Okay, if you are only looking for tasks during March 28 I believe this
may work. I have not done extensive testing but give this a try:

Insert a spare date field (Date1) in your table and enter the date
3/28/07 8:01 am. Copy that date to all rows (fill down would work) in
the project file.

Insert a spare Flag field (Flag1) and use the following formula:

IIf([Start]<[Date1] And [Finish]>[Date1],"Yes","No")

This should show "Yes" for tasks with start before 8:01 and finish after
8:01.

Then use an autofilter for Flag1 equal to "Yes".

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project