Solved

How do I get a list of start times in MS Project?

Posted on 2013-01-08
6
229 Views
Last Modified: 2013-03-19
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.
0
Comment
Question by:DrDamnit
  • 3
  • 2
6 Comments
 
LVL 12

Expert Comment

by:thausla
ID: 38758126
Hi,

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
0
 
LVL 32

Author Comment

by:DrDamnit
ID: 38767144
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:

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....

Open in new window


You get the point?
0
 
LVL 12

Expert Comment

by:thausla
ID: 38767818
Got it and will give it a thought.
0
Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

 
LVL 32

Author Comment

by:DrDamnit
ID: 38904203
Any update on this?
0
 
LVL 18

Accepted Solution

by:
xtermie earned 500 total points
ID: 38917834
You could probably get a tool like the one described here:
http://docs.groove.net/htmldocs/guide/tools/business/grooveprojecttoolset/projecttracking/project_microsoft3x.htm
or
use Office Timesheets
http://www.officetimesheets.com/products/microsoft_project_interface.aspx

Now a simple workaround would be to export tasks into Excel as described here:
http://almurray.hubpages.com/hub/Export-Microsoft-Project-Data-into-Excel

and then have a go at Excel, where it is easier to get what you want.
0
 
LVL 32

Author Closing Comment

by:DrDamnit
ID: 39001321
Export to excel it is.
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will show you how to use shortcut menus in the Access run-time environment.
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question