Forum home » Delegate support and help forum » Microsoft Excel Training and help » MS Project

MS Project

ResolvedVersion 2003

Thu 4 Dec 2008, 16:18 Delegate David said...

David has attended:
Project Intro Intermediate course
Excel Intermediate course

MS Project

Is there a way you can graphically visualize predecesors for one activity similar to the way you visualize predecesor cells using Formula Audit Toolbar functions in Ms Excel?

Fri 5 Dec 2008, 16:34 Trainer Andrew said...

RE: MS Project

Hi David

Thanks for your question. Project 2007 has a feature called Drivers which allows you to select a task and then display the factors influencing its position in the Gantt chart. In earlier versions of Project the best way to see this would be through a combination of fields such as Predecessors and columns in tables such as Tracking.

I hope this helps - let us know if you have any further questions.

Kind regards,
Andrew

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Calculate difference between two times

For presenting the result in the standard time format (hours : minutes : seconds . Use the subtraction operator (-) to find the difference between times, and the TEXT function to format the returned value to text in a specific number format.

Hours never exceed 24, minutes never exceed 60, and seconds never exceed 60.

=TEXT(B2-A2,"h")
Hours between two times (4)

=TEXT(B2-A2,"h:mm")
Hours and minutes between two times (4:55)

=TEXT(B2-A2,"h:mm:ss")
Hours and seconds between two times (4:55:00)

Where B2 and A2 must hold the end time and start time respectively formatted as a time format

View all Excel hints and tips

MS Project

MS Project

RE: MS Project

Excel articles

Excel tip:

Calculate difference between two times