![]() |
|
|
|
#1
|
|||
|
|||
|
Hi All,
I was wondering if someone could tell me how i can create a progress bar to show the time remaining between two dates. I want to create a to do list, but i want to set a completion date and have a progress bar that will move up as it gets nearer to the completion date so that i can see how much time is remaining to complete that task Hopefully this makes sense Thanks |
|
#2
|
|||
|
|||
|
See attached. First column is Due Dates. Second column is a calculation, Due Date-Now() with data bar conditional formatting applied (showing bars only-the data are hidden).
Does that suit your needs? |
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
updating task progress
|
ketanco | Project | 1 | 08-16-2012 05:09 AM |
| How to create a progress bar | AfterLife6 | Excel | 1 | 07-31-2012 08:43 PM |
adjusting remaining work per status date
|
ketanco | Project | 1 | 03-16-2012 06:02 AM |
| remaining duration vs finish date | ketanco | Project | 3 | 02-17-2012 02:24 PM |
| Automatic resouce assignment of remaining unallocated units | philk | Project | 0 | 05-04-2011 04:57 PM |