RE: How do i calculate the difference between start and end dates?

Tech-Archive recommends: Speed Up your PC by fixing your registry



I am not sure I fully understand why duration as calculated by MS project is
not what you are looking for. But based on your example, have you thought of
taking the difference of the Actual Start Date and Actual Finish Date fields?
You could probably set up a custom field to calculate this automatically.
But I think this calculation may end up giving you the same result as the
duration field would. It’s worth a try and compare the two.

"Dennis Meyer" wrote:

> I need to know how long it takes to deliver a task... not how many working
> hours are involved (duration as calcualted by MS Project), but what is the
> absolute difference between the start date/time and end date/time? I can
> manually count the number of days and hours between the start date and end
> date, but...
>
> For example, I start a task on Tues 7/5/05 8:00AM and finish it on Sun
> 7/17/05 7:39 PM. The time it took to deliver the task was 12 days and almost
> 12 hours. Project calculates duration as 15.71 days, because some resources
> work different shifts (8hrs, 12hrs, 10hrs). The duration as calculated is
> useful, but not exactly what I need.
>
> Anyone out there able to help?
>
> Thanks.
>
.



Relevant Pages

  • RE: Calculating next due date in a form
    ... Date/Time data types are a point in time, not a duration. ... is a calculation between two times and is not represented as point it time. ... For each installation there is an install table which links to job_id ...
    (microsoft.public.access.forms)
  • Re: Setting that stops a Date from being fixed
    ... changed a duration before a task that was started - all the start dates ... It is done - just that I wanted the graph to show it inline with the other ... calculation rules I make up, ... End dates will recalculate as long as %complete is less than ...
    (microsoft.public.project)
  • Re: Need a simple formula to calculate EV and PV seperately
    ... calculation for purposes of basic Earned Value Management. ... Cost of Work Scheduled and associated derived metrics, ... Regardless of whether the user enters the % Complete or Actual Duration ... Complete for summary tasks, we can follow a similar method to establish ...
    (microsoft.public.project)
  • Re: Setting that stops a Date from being fixed
    ... calculation rules I make up, ... would systematically introduce Actual duration and remaining duration ... graph looks as I want it to. ... End dates will recalculate as long as %complete is less than ...
    (microsoft.public.project)
  • Re: Custom fields and internal values
    ... calculation. ... that reads [Duration], I can see a 4 day duration task is shown as ... How did the person know to compare Baseline finish to 10000? ... How is MS Project storing this? ...
    (microsoft.public.project)