weird ActiveProject.HoursPerDay

[Robert]

Hi,
I'm trying to use the ActiveProject.HoursPerDay property in a VBA procedure,
but it returns the value 16 while my project is set to 7 hours/day.
Is this a bug or did I put too much wiskey in my coffee ?
Thanks for your help!

 

[Jan De Messemaeker]

Hi,

Look in Tools, Options, Calendar.
There you find hours per day, not in Change Working time.

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[John]

Hi,
I'm trying to use the ActiveProject.HoursPerDay property in a VBA procedure,
but it returns the value 16 while my project is set to 7 hours/day.
Is this a bug or did I put too much wiskey in my coffee ?
Thanks for your help!

Robert,
Although Jan answered the question, let me elaborate a bit. If you are
looking at the Project calendar under Tools/Change Working Time, that
specifies the working hours for any given day. However, the hours per
day under Tools/Options/Calendar is actually a factor that Project uses
to calculate duration - it is NOT the number of working hours per day.
The ActiveProject.HoursPerDay statement is giving the latter value.

Normally the hours per day under Tools/Options/Calendar would be synced
with the working hours so that durations are consistent.

Hope that helps.
John
Project MVP

 

[Robert]

Jan,

Definitely, in Tools / Options / Calendar, I have "Hours per day" : 7,00

Robert

 

[John]

Jan,

Definitely, in Tools / Options / Calendar, I have "Hours per day" : 7,00

Robert

Robert,
I can't speak for Jan, but I'd like to see that one. Are you sure the
active project is the one with "7" under Tools/Options/Calendar tab? My
guess is that either it is not the active project or you are trying to
run your procedure on a master file or some other linked configuration
(e.g. resource pool).

If you absolutely swear that there is nothing strange in your coffee and
that the active project is the one with the hours per day set to 7, then
I'd like to see the file. It wouldn't hurt to see your macro also. If
you're game, you can send it to my address below

John
Project MVP
jensenj6atatcomcastdotdotnet
(remove obvious redundancies)