Dear team,
i am attaching data.
in this different different dates & event start time given against main site id.
i need a macro for this when my time difference in event time <=10 than it will take as 1 incident for particular date.
for example
30-10-2005 10:02 abcd
30-10-2005 10.08 abcd
30-10-2005 10.10 abcd it will count 1
31-10-2005 10.02 abcd means count 2
your help is appreciated.
regards
kuldeep
Bookmarks