LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to find the correct program to download an .xls attachment sportshistorybuff Excel Discussion (Misc queries) 2 June 30th 06 04:49 PM
Can you find me a cash out program for a restaurant / bar? GP007 Excel Discussion (Misc queries) 1 November 3rd 05 01:36 PM
convert time from 60 minute hour to 100 minute hour Jboerding Excel Discussion (Misc queries) 2 July 6th 05 11:30 PM
How do I activate the trial exel 2003 program if it does't find c. Dolores Dueck New Users to Excel 1 January 3rd 05 02:19 AM
convert 100 minute hour to a 60 minute hour Todd Excel Worksheet Functions 1 November 15th 04 06:14 PM


All times are GMT +1. The time now is 10:51 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"