Results 1 to 3 of 3

Thread: Elapsed time Changes Condition

  1. #1
    Neophyte bevil's Avatar
    Join Date
    Mar 2017
    Location
    Phx, AZ
    Posts
    2
    Articles
    0

    Red face Elapsed time Changes Condition



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

  2. #2
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    723
    Articles
    0
    Quote Originally Posted by bevil View Post
    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.

  3. #3
    Neophyte bevil's Avatar
    Join Date
    Mar 2017
    Location
    Phx, AZ
    Posts
    2
    Articles
    0
    Thanks I'll try it.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •