decimal duration

R

ruth

hi, please can i know how i can change my total durations from decimal days to whole number days
regards
 
R

Rod Gill

Hi,

You need to write and run a VBA macro to do this. Try running the attached
on a copy of your schedule:

Sub test()
Dim T As Task
For Each T In ActiveProject.Tasks
If Not T Is Nothing Then
T.Duration = Round(T.Duration / 60 / ActiveProject.HoursPerDay,
0) * 60 * ActiveProject.HoursPerDay
End If
Next T
End Sub


--
For VBA posts, please use the public.project.developer group.
For any version of Project use public.project
For any version of Project Server use public. project.server

Rod Gill
Project MVP
For Microsoft Project companion projects, best practices and Project VBA
development services
visit www.projectlearning.com/
 

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