Bill said:
Hi,
I am importing a duration from access. The units are integers in the access
table but in project the values are too small. In Project Tools, options,
Schedule, Duration is set to days.
Any ideas please.
Ta.
Bill
Bill,
Yes, but Project works with minutes at the database level. My guess is
that Project is interpreting the access values as minutes so when
displayed as days per the option setting they will indeed be very small.
You can either modify the Access database so that duration values are in
minutes or you can make the translation in Project.
To make the translation in Project, one way is to dump the imported
values into a spare text field (e.g. Text1). Then use a customized field
with a formula to apply the appropriate factor - normally this is 480
for standard 8 hour working days. For example, let's say the imported
value is in spare Text1 and that value is supposed to represent days.
You could put the following formula in spare Text2:
Text2=Text1*480
Then filter for all non-summary tasks and copy the contents of the Text2
field to the Duration field for all task shown in the filtered view. The
end result should give what you want.
Hope this helps.
John
Project MVP
