minutes to hours duration

[theintern]

I am importing duration values of tasks from Microsoft Access in hours. It
was working fine, but now it seems to be thinking the values coming in are
hundredths of minutes, and then converting them to hours. For example, it
should import 12 hours, but instead it reads in .02 hours. Any idea what
changed? what's going on?

thanks
scott

 

[theintern]

Also, it started doing this after i started playing around with exporting the
data back to Access. it was converting the duration values on the way out as
well. I've given up on the exporting (after the process erased my entire
database, costing me hours of work) but i need to get this duration working
again.

thanks
scott

 

[Jan De Messemaeker]

Hi,
Duration= number of days * (hours per day)*60
Hours per day can be found under tols, options, calendar.
If you just import a number, you will need that multplication
However if you import the string "12d" no need to coonvert.
HTH
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[Jack Dahlgren]

I think work is stored in the database in hundredths of minutes. You might
need to apply a conversion factor to get it to the value you want. Give it a
try.

-Jack Dahlgren

 

[Rod Gill]

What version of Project (and SP level), how are you importing and what value
is stored in the Access db?

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

 

[theintern]

Thank you both for your replies. I ended up coding it to add the suffix
"hrs" before importing so there's no ambiguity.

thanks!
scott