Hi,

I seeking for a report from raw data which is coming to my system automatically from OEM software. Raw data consist of every 5 min ( Date format is mm:dd:yyyy hh:mm:ss AM/PM)reading/value of meter. But I wan to generate daily , weekly , monthly report from Raw data. Here 1st I want to pull data every one hour. Please find the attached sample sheet for the same. Sample sheet having 3 sheets. Trend sheet is my raw data and I want to extract data to daily report sheet based on date. If I enter date manually in daily report sheet B2 , data has to come from trend sheet for every 1 hour only( Hour mentioned in A5 to A28. ). Please kindly help me to save my most of the time.

Please find the below file link

https://drive.google.com/file/d/0B9B...ew?usp=sharing

Thanks in Advance.