CHange 15 minute data to hourly data or skip 3 cells in Excel

Hello All,

I have a data that is in 15 minute format. I want to change it to hourly format.

Suppose the data looks like this :
4/1/10 0:00 1217.89
4/1/10 0:15 1217.89
4/1/10 0:30 1217.89
4/1/10 0:45 1217.89
4/1/10 1:00 1217.89
4/1/10 1:15 1217.89
4/1/10 1:30 1217.89
4/1/10 1:45 1217.89
4/1/10 2:00 1217.89
4/1/10 2:15 1217.89
4/1/10 2:30 1217.89
4/1/10 2:45 1217.89
4/1/10 3:00 1217.89
4/1/10 3:15 1217.89
4/1/10 3:30 1217.89
4/1/10 3:45 1217.89
4/1/10 4:00 1217.89
4/1/10 4:15 1217.89
4/1/10 4:30 1217.89

I want to transform this data into hourly format. I just want the data for 0:00, 1:00, 2:00, 3:00 and so on.

What is the easiest method to do this ? I have very large amount of Data. WOuld you please help me solve this problem?

Thanks

jdbaba

Make sure there is a header row, with Hour in D1, then add this formula into column D

=MOD(B1*24,1)=0

and copy down.

In some cells, say M1:M2 as Hour, TRUE and then use Advanced Filter with Criteria Range of M1:M2 and Unique Records.