DrDamnit
asked on
How do I get a list of start times in MS Project?
My Gantt chart rocks. All tasks are entered, coded, divided, etc... but I want a list of tasks as they have been scheduled:
Tuesday 2:30pm Task 1 (1 Hour)
Tuesday 3:30pm Task 2 (4 Hours)
Wednesday 8:00am Task 2 (Continued)
Wednesday 11:00am Task 3
....
Etc...
How do I get this?
I am using Office Project 2007.
Tuesday 2:30pm Task 1 (1 Hour)
Tuesday 3:30pm Task 2 (4 Hours)
Wednesday 8:00am Task 2 (Continued)
Wednesday 11:00am Task 3
....
Etc...
How do I get this?
I am using Office Project 2007.
ASKER
Not quite. What I want is a start day and time for each task (and preferrably... how long I should spend on it.)
For example, Friday (Today) has an odd set of working hours 10-12, then 1-4pm. I also have 5 tasks that fall within that time frame. The first one will consume 10-12 and the 1-1:30. The next 3 fit neatly into the time left, and the last one is a 1.5 hour task that starts at 4:30 (so it iwll roll over into the first hour of Monday).
I want a spreadsheet or list that tells me the start times and durations of each task so I know exactly what's going on.
I can kind of get this is I zoom in the gannt chart, but that's more analog...
I want:
You get the point?
For example, Friday (Today) has an odd set of working hours 10-12, then 1-4pm. I also have 5 tasks that fall within that time frame. The first one will consume 10-12 and the 1-1:30. The next 3 fit neatly into the time left, and the last one is a 1.5 hour task that starts at 4:30 (so it iwll roll over into the first hour of Monday).
I want a spreadsheet or list that tells me the start times and durations of each task so I know exactly what's going on.
I can kind of get this is I zoom in the gannt chart, but that's more analog...
I want:
Task 1: Start: 10am End: 12pm
Task 1: Start 12:00pm End :12:30
Task 2: Start 12:30 End:2:30
Task 3: Start 2:30 End: 3:00
Task 4: Start 3:00 End 4:30
Task 5: Start 4:30 End 5:00 (Continued on next day)
Day 2:
Task 5: Start 8:00 End....
You get the point?
Got it and will give it a thought.
ASKER
Any update on this?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Export to excel it is.
I guess you have your schedule structured i.e. summary tasks, normal tasks and milestones? Then you need to filter out the summary tasks first by creating and applying a new filter with "Summary" "equals" "No".
After you filtered on the non-summary tasks you can simply sort by the start date column and get all tasks in the desired order.
Is this what you are looking for?
Regards
Thomas