MS Project Filter: How can I get MS project to accept my start/competion dates and show up on the calendar?
December 20, 2010 7:03 AM Subscribe
MS Project Filter: How can I get MS project to accept my start/competion dates and show up on the calendar?
I am using MS Project to map utilization of a resource from several years ago - inputting project start times, and the project end times.
I did a mass import of several columns from an excel spreadsheet - start date/time, task name, finish date/time, and resource names.
What I'd really like to be able to do is calculate the amount of time outside of normal business hours (8-5, M-F) that tasks were being worked, but when I use a standard calendar, it doesn't accept that some tasks were finished at 2am, or 11pm and instead resets the times and changes the duration.
Also, when I look at the calendar, some weeks are completely empty (no tasks), but when I click on the down arrow in the day column (during the "empty" week), it shows several tasks which were in progress that day. Yesterday while tinkering with settings, for some reason, a lot of my projects were extended - - tasks which started one day and finished on the next had a duration of six days. Now, having wiped the project and started again, the (calculated using excel) duration of 63 days shows up as 70 on project (with similar errors for other resources)
How do I set this up so that it'll just show the tasks completed without trying to adjust them? Bonus points if I can calculate non-used normal-workday time.
I am using MS Project to map utilization of a resource from several years ago - inputting project start times, and the project end times.
I did a mass import of several columns from an excel spreadsheet - start date/time, task name, finish date/time, and resource names.
What I'd really like to be able to do is calculate the amount of time outside of normal business hours (8-5, M-F) that tasks were being worked, but when I use a standard calendar, it doesn't accept that some tasks were finished at 2am, or 11pm and instead resets the times and changes the duration.
Also, when I look at the calendar, some weeks are completely empty (no tasks), but when I click on the down arrow in the day column (during the "empty" week), it shows several tasks which were in progress that day. Yesterday while tinkering with settings, for some reason, a lot of my projects were extended - - tasks which started one day and finished on the next had a duration of six days. Now, having wiped the project and started again, the (calculated using excel) duration of 63 days shows up as 70 on project (with similar errors for other resources)
How do I set this up so that it'll just show the tasks completed without trying to adjust them? Bonus points if I can calculate non-used normal-workday time.
« Older Need help formatting an Access report from a query... | PATA to SATA power adapter needed in Forest Hills... Newer »
This thread is closed to new comments.