Need corresponding hourly values (24per day) daily from multiple

Closed
arunjyoti.ec Posts 1 Registration date Monday July 27, 2015 Status Member Last seen July 27, 2015 - Jul 27, 2015 at 09:22 PM
I need a formula which will select data automatically from raw data sheet considering to near by (Corresponding) every hour duration. There should be not adding or average of one hour duration data.e.g:-
if i have following data :-
Date & time Value
6/30/2015 23:55 4
6/30/2015 23:35 3
6/30/2015 23:19 6
6/30/2015 22:59 5
6/30/2015 22:44 8
6/30/2015 22:24 3
6/30/2015 22:09 8
.
.
.
6/01/2015 23:09 7
The result should be in another sheet :-

6/30/2015 24:00 4
6/30/2015 23:00 5
6/30/2015 22:00 8
.
.
.
6/01/2015 23:00 7
I need only 24 readings per day on hour basis from raw data without adding or averaging at that duration data. The Problem is raw data is in random form i.e we are getting 2 data sets/hour,3 data sets/hour,4 data sets/hour so i am not able to pick alternate values or nth value in sheet.

I want to develop a sheet in which i want to paste data in raw data sheet i will get result data in dashboard sheet.


with regards,
Arun