durations

T

Tom S

If I wanted duration to only be presented in weeks (not days, or hours), how
do I get it to do that
 
J

John

Tom,
First go to Tools/Options/Schedule tab and set the Duration for "weeks".
Then if the file already has existing tasks whose Duration is shown in
days, run the following macro to make the change.
Sub DayToWk()
For Each t In ActiveProject.Tasks
If Not t Is Nothing Then
If t.Summary = False Then t.Duration = t.Duration / 2400 & "wks"
End If
Next t
End Sub

Once the option has been set and existing tasks have been converted any
new tasks entered will have a Duration of weeks.

Hope this helps.
John
 
S

Steve House

Why go through the trouble of reinventing the wheel? There's a macro called
"format duration" that's standard equipment with Project out of the box that
changes durations to any desired units.
 
J

John

Steve,
You are right. To be honest I never even noticed that there already was
a built-in macro for that. I'm so used to doing my own macros I rarely
bother with the built-in stuff.

John
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top