none
Project Duration doesn't equal duration given in Excel RRS feed

  • Question

  • I have an Excel file linked to my Project Schedule.

    When I compare task durations, they differ.

    e.g. the excel file will say 70 days but Project will say 73.5 days even though the start and finish dates are the same.

    The working week has been set to 7 days in Project and there don't appear to be any exceptions.

    Thoughts?

    thanks

    Matthew

    Friday, March 14, 2014 8:59 PM

Answers

  • I have a calendar which allows 7 working days per week with a working time from 08:00 to 17:00 per day and a break from 12:00 10 13:00.  There are no non-working days in the calendar.

    If I create a autoscheduled task in Project starting July 3, 2015 at 08:00 and enter a 70 day duration, I see a finish of Sept 10, 2015 at 17:00 pm.  71 days in duration takes the task finish date to Sept 11, 2015 at 5:00 pm.  If I enter July 3, 2015 08:00 to Sept 11, 2015 17:00 in Excel, I see a duration 70.375.  I believe Excel counts the hours paying no attention to the nonworking time in Project after 5:00 pm.  If I change the calendar in Project to the 24 hours calendar, change the definition of day to 24 hours, a 70 day duration task starts on July 3, 2015 08:00 and ends on Sept 11, 2015 at 08:00.

    • Marked as answer by Matt7288 Monday, March 17, 2014 6:30 AM
    Sunday, March 16, 2014 7:31 PM
    Moderator

All replies

  • Please check File > Options, Schedule and let us know what your definition of hours per day and hours per week is.

    Excel's date usually are set at 12:00 am  on the date- whereas Project's default start time is 08:00 am.

    Format the dates in Excel to show time and then format Project to show time (File > Options, General).

    Sunday, March 16, 2014 3:28 PM
    Moderator
  • Hi,

    The hours per week shows 40, start at 08:00 End at 17:00; 8 hours per day and 31 days per month.

    I changed excel to read date and 08:00.  and copied the data over.

    This time I get 70 days in excel and 72.5 days in project for the period 3/7/15 to 11/9/15.

    many thanks for helping with this

    Matthew

    Sunday, March 16, 2014 4:29 PM
  • I have a calendar which allows 7 working days per week with a working time from 08:00 to 17:00 per day and a break from 12:00 10 13:00.  There are no non-working days in the calendar.

    If I create a autoscheduled task in Project starting July 3, 2015 at 08:00 and enter a 70 day duration, I see a finish of Sept 10, 2015 at 17:00 pm.  71 days in duration takes the task finish date to Sept 11, 2015 at 5:00 pm.  If I enter July 3, 2015 08:00 to Sept 11, 2015 17:00 in Excel, I see a duration 70.375.  I believe Excel counts the hours paying no attention to the nonworking time in Project after 5:00 pm.  If I change the calendar in Project to the 24 hours calendar, change the definition of day to 24 hours, a 70 day duration task starts on July 3, 2015 08:00 and ends on Sept 11, 2015 at 08:00.

    • Marked as answer by Matt7288 Monday, March 17, 2014 6:30 AM
    Sunday, March 16, 2014 7:31 PM
    Moderator
  • many thanks Julie, Matthew
    Monday, March 17, 2014 6:30 AM
  • You're welcome, Matt and thank you for the feedback.
    Monday, March 17, 2014 12:23 PM
    Moderator