Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-12-2014, 10:45 AM
teza2k06 teza2k06 is offline Time Remaining Progress Bar Windows 7 64bit Time Remaining Progress Bar Office 2010 32bit
Advanced Beginner
Time Remaining Progress Bar
 
Join Date: Feb 2013
Posts: 37
teza2k06 is on a distinguished road
Default Time Remaining Progress Bar

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
Reply With Quote
  #2  
Old 05-13-2014, 05:41 AM
gebobs gebobs is offline Time Remaining Progress Bar Windows 7 64bit Time Remaining Progress Bar Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

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?
Attached Files
File Type: xlsx Progress.xlsx (10.1 KB, 67 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Time Remaining Progress Bar 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
Time Remaining Progress Bar 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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:37 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft