+ Reply to Thread
Results 1 to 4 of 4

Calculate days elapsed based on criteria from other cells

  1. 11-05-2014, 11:39 AM #1
    jmcnea
    jmcnea is offline
    Registered User
    Join Date
    11-05-2014
    Location
    Virginia
    MS-Off Ver
    2010
    Posts
    2

    Calculate days elapsed based on criteria from other cells

    Hello,
    I need help trying to figure out how to calculate the days elapsed in a step. Currently I have to manually go in and select the cells to use in the calculation. I would like to calculate the time from "To move" to previous "To Move" - see attached. Thanks
    excel help.xlsx
    Attached Images Attached Images
    Last edited by jmcnea; 11-05-2014 at 11:43 AM.
    Reply With QuoteRegister To Reply
  2. 11-05-2014, 12:59 PM #2
    Jonmo1
    Jonmo1 is offline
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Calculate days elapsed based on criteria from other cells

    Try this in K3 and filled down

    =IF(G3="To Move",B3-LOOKUP(2,1/($G$2:$G2="To Move"),$B$2:$B2),"")
    Reply With QuoteRegister To Reply
  3. 11-11-2014, 12:08 PM #3
    jmcnea
    jmcnea is offline
    Registered User
    Join Date
    11-05-2014
    Location
    Virginia
    MS-Off Ver
    2010
    Posts
    2

    Re: Calculate days elapsed based on criteria from other cells

    That worked great, thank you!
    Reply With QuoteRegister To Reply
  4. 11-11-2014, 12:09 PM #4
    Jonmo1
    Jonmo1 is offline
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Calculate days elapsed based on criteria from other cells

    You're welcome
    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)

Similar Threads

  1. Please help with formula to calculate elapsed business days & time from two combined cells
    By bgcm in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-21-2014, 04:14 PM
  2. [SOLVED] calculate numbers of days elapsed a week, month or 6 months from now
    By labogola in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 01-01-2014, 09:14 AM
  3. How to calculate elapsed time between to days excluding weekends.
    By Mush001 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-23-2009, 04:19 PM
  4. How to Calculate Days elapsed where Weekend is calculated as 1 Working Day?
    By speakbones in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-14-2007, 07:20 PM
  5. [SOLVED] Calculate elapsed working days
    By RUSH2CROCHET in forum Excel General
    Replies: 6
    Last Post: 03-09-2006, 04:40 PM

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