Average Times By Month

    I am looking for a macro that will allow me to find the mean for all of a specific time during a month. For Example, I want to find the average percentage of capacity for every day at 11:00 am for the month of January.


    thanks.


    P.S. for info purposes, the columns below are from columns G,H, and I of my spreadsheet.



    Percentage of Capacity By Hour Hour Month/Day/Year
    0.00% 11:00 1/22/2007
    0.00% 12:00 1/22/2007
    0.00% 13:00 1/22/2007
    0.00% 14:00 1/22/2007
    0.00% 15:00 1/22/2007
    0.00% 16:00 1/22/2007
    0.00% 17:00 1/22/2007
    0.00% 18:00 1/22/2007
    0.00% 19:00 1/22/2007
    0.00% 20:00 1/22/2007
    0.76% 21:00 1/22/2007
    1.59% 22:00 1/22/2007
    1.38% 23:00 1/22/2007
    2.68% 0:00 1/23/2007
    1.75% 1:00 1/23/2007
    3.65% 2:00 1/23/2007
    3.40% 3:00 1/23/2007
    2.41% 4:00 1/23/2007

    Re: Macro To Average Specific Times During A Month


    ferretydeath,

    MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question

    *


    PM Dave Hawley if you agree to the forum rules


    VBA Noob

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login