LinkBack URL
About LinkBacks
Hello,
I would like to average data between 0600 and 2200 hours, between two date ranges, such as July 1st and July 31st.
Any help would be apprecaited,
Thanks in advance..Capture.JPG
Hello,
I would like to average data between 0600 and 2200 hours, between two date ranges, such as July 1st and July 31st.
Any help would be apprecaited,
Thanks in advance..Capture.JPG
Last edited by mkadon; 08-24-2014 at 11:51 AM.
I suggest you attach a sample workbook (the FAQ describes how to) so that we can see which columns you are using for the dates and hours (which may be combined) and how you want the results to be presented.
Pete
Make a helpcolumn to determine the criteria.
After that, make a pivot table of the data (and select average in the values).
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Thread posted in Commercial services, hence closed.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks