average of certain data between two dates and times in Excel

Posted on 2011-04-27
Last Modified: 2012-05-11
I need to be able to average data between two dates and times.  In the example file, I need to (for example) average the Data in column D for the time period 10/13/10 7:36 - 10/13/10 7:40.

Id like code that I can use so that this can be accomplished in one cell - because I have to average many various dates and times this way.

Thanks in advance Book1.xlsx
Question by:SullivanEnvironmental
    1 Comment
    LVL 50

    Accepted Solution

    If you put the start time/date in I4 and the end time/date in J4 you can use this formula in K4 for the average between those two times inclusive


    You can list more time ranges below then just copy the formula down

    see attached

    regards, barry

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    How to Win a Jar of Candy Corn: A Scientific Approach! I love mathematics. If you love mathematics also, you may enjoy this tip on how to use math to win your own jar of candy corn and to impress your friends. As I said, I love math, but I gu…
    This article seeks to propel the full implementation of geothermal power plants in Mexico as a renewable energy source.
    This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
    This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now