+ Reply to Thread
Results 1 to 7 of 7

Time elapsed converted to a %

  1. 04-28-2011, 06:08 PM #1
    eitherorr
    eitherorr is offline
    Registered User
    Join Date
    04-28-2011
    Location
    San Diego, CA
    MS-Off Ver
    Excel 2007
    Posts
    12

    Time elapsed converted to a %

    I have searched the forums and have not been successfull in finding an answer to my problem. I have a period of performance, begin date (11/01/2010) and end date(10/31/2011). I need to calculate the % of time elapsed and remaining based on today's date.
    Reply With QuoteRegister To Reply
  2. 04-28-2011, 06:20 PM #2
    tigeravatar
    tigeravatar is offline
    Forum Expert tigeravatar's Avatar
    Join Date
    03-25-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2003 - 2013
    Posts
    5,361

    Re: Time elapsed converted to a %

    eitherorr,

    See attached.

    Hope this helps,
    ~tigeravatar
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 04-28-2011, 06:22 PM #3
    MarvinP
    MarvinP is offline
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,441

    Re: Time elapsed converted to a %

    Hi eitherorr and welcome to the forum

    Find the attached that should explain how to do it. You need to know you can subtract dates in excel and it will give the number of days between the two.
    Attached Files Attached Files
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.
    Reply With QuoteRegister To Reply
  4. 04-28-2011, 06:22 PM #4
    eitherorr
    eitherorr is offline
    Registered User
    Join Date
    04-28-2011
    Location
    San Diego, CA
    MS-Off Ver
    Excel 2007
    Posts
    12

    Re: Time elapsed converted to a %

    It works! Thank you so much. Awesome!
    Reply With QuoteRegister To Reply
  5. 04-28-2011, 06:24 PM #5
    contaminated
    contaminated is offline
    Forum Expert contaminated's Avatar
    Join Date
    05-07-2009
    Location
    Baku, Azerbaijan
    MS-Off Ver
    Excel 2013
    Posts
    1,430

    Re: Time elapsed converted to a %

    Try

    =(TODAY()-StartDate)/(EndDate-StartDate)

    Format Output in percentage format. Based on your sample result would be 71.88%
    Люди, питающие благие намерения, как раз и становятся чудовищами.

    Regards, ?Born in USSR?
    Vusal M Dadashev
    Baku, Azerbaijan
    Reply With QuoteRegister To Reply
  6. 04-28-2011, 06:28 PM #6
    tigeravatar
    tigeravatar is offline
    Forum Expert tigeravatar's Avatar
    Join Date
    03-25-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2003 - 2013
    Posts
    5,361

    Re: Time elapsed converted to a %

    contaminated,

    umm... The date and time in order for the result to be 71.88% would have to be July 20, 2011 at 3:26:12 PM....
    Reply With QuoteRegister To Reply
  7. 04-28-2011, 06:31 PM #7
    eitherorr
    eitherorr is offline
    Registered User
    Join Date
    04-28-2011
    Location
    San Diego, CA
    MS-Off Ver
    Excel 2007
    Posts
    12

    Re: Time elapsed converted to a %

    This is so great! Thank you all so very much, so many ways to solve my problem and they all work! Awesome!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1