+ Reply to Thread
Results 1 to 3 of 3

Calculate Average Time between Two Rows in a Range of Many Non-Consectuive Rows

  1. #1
    Registered User
    Join Date
    06-19-2012
    Location
    Atlanta, GA
    MS-Off Ver
    Excel 2007
    Posts
    24

    Calculate Average Time between Two Rows in a Range of Many Non-Consectuive Rows

    This may be a simple question, but I've been having trouble getting to the end result. I have a spreadsheet of production data that I filter based on the date and the worker. One of the columns, I'm working with is the time that each job was started. So for example:
    Confirmation time
    8:39:11 AM
    8:52:04 AM
    8:52:29 AM
    9:08:48 AM
    9:09:29 AM
    9:10:03 AM
    9:11:09 AM
    9:20:51 AM


    I want to calculate the average time between all rows. I was thinking this may be just a simple standard deviation, but the results don't seem right...
    The main problem I'm running into is that these rows are not consecutive since the spreadsheet was filtered.

    Any guidance or suggestions would be much appreciated.

    I feel like there must be a simple answer to this...

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Calculate Average Time between Two Rows in a Range of Many Non-Consectuive Rows

    A
    B
    C
    1
    Confirmation time
    2
    8:39:11 AM
    9:03:01 AM
    B2: =AVERAGE(A2:A9)
    3
    8:52:04 AM
    4
    8:52:29 AM
    5
    9:08:48 AM
    6
    9:09:29 AM
    7
    9:10:03 AM
    8
    9:11:09 AM
    9
    9:20:51 AM
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Calculate Average Time between Two Rows in a Range of Many Non-Consectuive Rows

    Or you mean the average difference between rows?

    A
    B
    C
    1
    Confirmation time
    2
    8:39:11 AM
    0:05:57
    B2: {=AVERAGE(A3:A9-A2:A8)}
    3
    8:52:04 AM
    4
    8:52:29 AM
    5
    9:08:48 AM
    6
    9:09:29 AM
    7
    9:10:03 AM
    8
    9:11:09 AM
    9
    9:20:51 AM


    The curly braces mean that you MUST confirm the formula with Ctrl+Shift+Enter instead of just Enter.

+ 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. Replies: 9
    Last Post: 05-10-2014, 11:01 AM
  2. Replies: 2
    Last Post: 03-15-2014, 07:28 AM
  3. Replies: 6
    Last Post: 11-25-2013, 08:35 PM
  4. [SOLVED] Can I calculate the average of subtotalled rows in a pivot table?
    By Stephd22 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-14-2013, 09:00 AM
  5. Average of range of dates with hidden / filtered rows
    By sullve07 in forum Excel General
    Replies: 3
    Last Post: 11-21-2010, 03:24 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