Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
visual basic coding question
Hi everyone
my first post and I am relatively new to vb so bear with me!! 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, when the date changes, i also wish a row to be inserted. I will post a copy of the vb i have up to now I hope you can help. Kind Regards Steven |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Micrsoft Visual Basic Compile error: Expected: end of statement | Excel Discussion (Misc queries) | |||
Visual basic editor | Excel Discussion (Misc queries) | |||
Macro Calling Visual Basic References | Excel Discussion (Misc queries) | |||
Visual Basic and VBA Forum | Excel Discussion (Misc queries) | |||
Formula in Visual Basic For Excel | Excel Discussion (Misc queries) |