Average Times By Month

Important Notice


Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

    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