excel macro - get hour high and low of day occur and frequency of the times over the time period

time of day the high takes place for each day time of day the low takes place for each day time of day the high takes place most often time of day the high takes place second most often time of day the high takes place third most often and some sort of chart showing this time of day the low takes place most often time of day the low takes place second most often time of day the low takes place second most often and some sort of chart showing this I need this for the entire data series and a separate one for the 2018 I would like to be able to copy and paste the formulas if possible into other spreadsheets