How do I know at what time of a day a resource is scheduled to wor

[Adrian]

I have to create a tasklist that displays how many hours a certain resource
has to work on a certain day.
Using VBA, I can read the amount of hours a resource is assigned to a task
on a certain day.
But I also want to know at what time of the day the work is scheduled.
Let's say there is a 20h task (fixed work).
I assign a work resource (units=1.0) that is available between 8:00 AM and
4:00 PM very day.

So the work is scheduled from 8:00 AM to 4:00 PM during the first two days
and from 8:00 AM to 12:00 PM on the third day.

Is there any way to access this information?
I would like to display the start and end time of the assignment during a
certain day next to the assigned work for that day.

I'd be happy about any suggestions on that.

Adrian

 

[Jan De Messemaeker]

Hi,

If MyAssgn is the assignment object then use
VBA.Timevalue(myassgn.start) or vba.timevalue(myassgn.finish)

HTH

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