+ Reply to Thread
Results 1 to 3 of 3

Averaging times between multiple dates

  1. #1
    Registered User
    Join Date
    07-07-2017
    Location
    Vallejo, California
    MS-Off Ver
    2010
    Posts
    5

    Exclamation Averaging times between multiple dates

    Is there a formula that I could use to average the times between a series of dates?

    My worksheet has two columns, column A is a start date and column B is an end date.
    I need to take the number of days between each start and end date to find the average
    number of days between all of the start and end dates.
    My table essentially looks like this:

    Start Date End Date
    1/1/01 1/4/01
    1/7/01 1/9/01
    1/10/01 1/15/01
    1/17/01 1/18/01
    1/20/01 1/26/01

    While the dates above are pretty easy to count and average in my head, the sheet I am
    working with has way more data; so I'm looking for an easier solution than mental math.
    Thanks!

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Averaging times between multiple dates

    perhaps this:


    v A B C
    1 Start Date End Date
    2 1/1/2001 1/4/2001 3
    3 1/7/2001 1/9/2001 2
    4 1/10/2001 1/15/2001 5
    5 1/17/2001 1/18/2001 1
    6 1/20/2001 1/26/2001 6
    7 3.4
    8

    v A B C
    1 Start Date End Date
    2 36892 36895 =DATEDIF(A2,B2,"D")
    3 36898 36900 =DATEDIF(A3,B3,"D")
    4 36901 36906 =DATEDIF(A4,B4,"D")
    5 36908 36909 =DATEDIF(A5,B5,"D")
    6 36911 36917 =DATEDIF(A6,B6,"D")
    7 =AVERAGE(C2:C6)
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Averaging times between multiple dates

    or =AVERAGE(DATEDIF($A$2:$A$6,$B$2:$B$6,"d")) array entered
    A2:A6 - start dates
    B2:B6 - end dates

+ 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. [SOLVED] Averaging the earliest start times and latest end times for multiple days
    By kbiro in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-26-2016, 02:15 PM
  2. [SOLVED] Auto filling dates based on previously entered dates and averaging numbers if dates equal
    By grambograham in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-11-2012, 03:21 PM
  3. [SOLVED] averaging times
    By SYBS in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-15-2006, 01:25 PM
  4. [SOLVED] Averaging Values between Two Dates/Times
    By ChrisM in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 11-15-2005, 11:20 PM
  5. Averaging values between two dates/times
    By ChrisM in forum Excel General
    Replies: 1
    Last Post: 11-14-2005, 11:30 AM
  6. Averaging Values between Two Dates/Times
    By ChrisM in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-14-2005, 11:15 AM
  7. Averaging Times w/ AM PM
    By krisennay in forum Excel General
    Replies: 1
    Last Post: 11-12-2005, 05:45 AM

Tags for this Thread

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