Results 1 to 2 of 2

Average based on date in previous column

Threaded View

  1. #1
    Registered User
    Join Date
    07-24-2012
    Location
    chicago
    MS-Off Ver
    Excel 2010
    Posts
    3

    Average based on date in previous column

    Hi, I am trying to average numbers in a column, C, where the number is dependent on the date and time in the previous 2 column. I am having touble devoloping a formula to do this. Below is an example of what I am trying to explain.

    A B C
    11/10/2011 0:15 12/12/2011 1:16 46141
    11/10/2011 0:16 12/19/2011 2:25 56289
    12/1/2011 5:12 12/4/2011 7:37 4465
    12/9/2011 0:22 1/20/2012 1:51 60569
    12/13/2011 0:04 12/13/2011 0:18 14


    Any help would be appreciated.
    Last edited by KayG; 07-24-2012 at 01:48 PM.

Thread Information

Users Browsing this Thread

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

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