+ Reply to Thread
Results 1 to 2 of 2

Accumulate time when true and when false turn it to cero.

  1. #1
    Registered User
    Join Date
    12-03-2008
    Location
    Barcelona
    Posts
    6

    Post Accumulate time when true and when false turn it to cero.

    Hello there,
    I have a big problem.
    I have this inputs
    Column A: Time
    Column B: Position Runner A in (%)
    Column C: Position Runner B in (%)
    Column D: Difference between A and B (%)
    Column E: Active time when I should calculate the time.
    The main problem is that I need to know how long does it take to Runner B to reach Runner A, while the active time (column E) is activated.
    I have calculate the time but in an accumulated way (column I), BUT I need to know how long does it take each time, and not that accumulate the time of the first race.
    I would like that once it reach Runner A, the calculate time will turn to 0 and then do it again when Runner A starts to run and starts to count form 0.
    As you can see I have try several things in columns F and G and H but I’m stuck.
    Attached Files Attached Files

  2. #2
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Accumulate time when true and when false turn it to cero.

    Hi
    Try this in I6
    =SUM(F6:F$269)-SUM(F5:F$269)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. What is best to use for helper cells 0 or 1, typed true or false or =true =false
    By Gingermuppet in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-20-2014, 10:41 PM
  2. [SOLVED] in this TRUE OR FALSE function, i want desired name instead of display true or false
    By vengatvj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-15-2013, 06:44 PM
  3. Replies: 3
    Last Post: 07-15-2006, 05:20 AM
  4. [SOLVED] Function to return True/False if all are validated as True by ISNU
    By Tetsuya Oguma in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-15-2006, 06:30 AM
  5. Reverse false and combine with true true value
    By Emmie99 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 PM
  6. Reverse false and combine with true true value
    By Emmie99 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 11:05 AM
  7. Reverse false and combine with true true value
    By Emmie99 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 PM
  8. [SOLVED] Reverse false and combine with true true value
    By Emmie99 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-17-2005, 12:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1