Hello,
You want to extract a single value every hour. What value do you want to extract? The last hours of the chosen?
If you want to extract all the values between two hours, the filter designed to operate. The area criterion can be for example
Code:
Date_hrs Date_hrs
> 01 / 01 / 2009 23: 00: 00 <02 / 01 / 09 00: 00: 00
If you want to do this on every hour, multiply the area of criteria and tables of results, so I do not think this is the best solution. Perhaps a PivotTable be more appropriate but I do not handle too much.
Bookmarks