Elapsed time Changes Condition

bevil

New member
Joined
Mar 20, 2017
Messages
2
Reaction score
0
Points
0
Location
Phx, AZ
Hi,
How do I write a formula that will give me a percentage based on elapsed time given a start date and an end date?
The second part of my question is that the percentage will change to red if the percentage completed falls behind expected percentage completed by date. Example there is 60 days between start date and end date if worked completed by day 31 is not at 50% or better the % would change color to red.
thanks
bevil
 
Hi,
How do I write a formula that will give me a percentage based on elapsed time given a start date and an end date?
I would suggest (TODAY() - Start date)*100/(End Date - Start Date)

To know whether the project was on time, you would also need a daily update on the percentage completed. This cell should be conditionally formatted red if its less than the above elapsed time percentage calculation.
 
Back
Top