How about remaining time?

D

Dewey

Hi
I'm just full of questions today. This one seems like it would be simple.
Is there a predefined sort to see the amount of time remaining in a task?
What I mean is the time between today and the end of the task, regardless of
how much of that task has already been completed (as opposed to "Remaining
Duration", which shows you the amount of work left to do based on % complete,
not the time you have to do it in.)

You guys are amazing.
Thanks for all the help.
-Josh
 
J

Jan De Messemaeker

Hi,

Sorry, but reamining duration is just that: "the time to do it in"
Your description fits remaining Work.
HTH
 
M

Mark Main

If you want to compute the number of days between today and the Finish date
then you could create a formula to do the computation using
Tools/Customize/Fields, and then modify one of the customizable fields.

For example you could use the following formula in Duration1:
=DateDiff("d",Now(),[Finish])*480

Note you need the * 480 because 1 day equal 480 in the duration field.

You could also put the following formula in the Number1 field:
=DateDiff("d",Now(),[Finish])

This allows you to Filter and Sort. A positive number shows that you still
have days remaining before the finish, and a negative number shows how many
days late.

I'm guessing that you will probably want to filter out tasks that are 100%
complete.

Mark Main, PMP
 
M

Mark Main

I forgot to mention that the formulas only work on tasks and milestones, they
don't calculate on summary levels.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top