Macro for Recognising Difference in Dates

[stevencarroll19]

Hi

I have a big report that can contain over 100000 rows, over two sheets in excel.

Basically, they log the time and date that a website was 'hit'. The report requires a great deal of formatting before any sense can be made of it. The following is the format of the data.

Date Time
01-Sep-06 12:46:50
01-Sep-06 12:46:51
01-Sep-06 12:46:52
01-Sep-06 12:46:52
01-Sep-06 12:46:52
01-Sep-06 12:46:52
01-Sep-06 15:01:47
01-Sep-06 15:01:47
01-Sep-06 15:01:48
01-Sep-06 15:01:48
01-Sep-06 15:02:01
01-Sep-06 15:02:47
01-Sep-06 15:02:47
01-Sep-06 15:02:47

What i am wanting to do (or hope one of you can help me in doing it ) is create a macro that compares each row as it goes down, deleting any rows where the time difference is <= 00:03:00 from the last row, or inserting an empty row where the difference > 00:03:00.

So the above data would be formatted to

01-Sep-06 12:46:50
01-Sep-06 12:46:52

01-Sep-06 15:01:47
01-Sep-06 15:02:47

In addition, if the time is 23:59:59, I need a blank row inserting. Any help would be very much appreciated.

Many Thanks

Steven