View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Striker Striker is offline
external usenet poster
 
Posts: 55
Default Program find a 5 minute gap

Excel 2007 [Square Brackets] used to represent a Cell. They do not exist
in the data of the cell.

I have a column spreadsheet that has 15K records. IN column "G" all records
have a date/tame like [2008-12-03 09:54:08.100]. What I need to do is
search through that column to the end of the file and find any gaps that may
be 5 minutes or longer and highlight that row.

So the above, I need to search 09:54 and see if the next row has 09:59 or
greater. If so highlight the row, if not move down one row and do the same
check. I'm looking to see if the row below is equal to or greater than a 5
minute difference from the cell above.

Does this make any sense?

I am aware I will most likely need to do this in code. I am using Excel
2007, and am somewhat familiar with modules, but have not worked with them
for a few years. Seems like I need a do until End of file and a for each
loop, but just a little lost on the details. Just got Excel 2007, so it's
new.

I also need to be careful to work with this workbook and this tab as there
will be many in the book.

Thanks for any help