I've an excel sheet that contains data every hour of the year. I'd like to filter the data to get the values from from 8 am to 4 pm for the weekdays only. Then I want to have the monthly total and average for the filtered data.
I'm using excel 360 on MAC OS.