LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 18
Default Finding data between blank rows

A B
1 6:00 a 7:00 a
2 7:05 a 8:30 a
3 8:35 a 10:00 a
4
5 12:00 p 1:00 p
6 1:05 p 4:00p
7
8 6:00p 10:00p

Each call-out will seperated by a blank row and, as shown above, can be made
up of single or mutiple rows. There may be only 1 call-out or up to 5 in a
day. I'm tring to find the start and stop times for each.
Start End
9 1st 6:00a 10:00a
10 2nd 12:00p 2:00p
11 3rd 5:00p 7:00p

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
FINDING THE FIRST ENTERED NUMBER IN A ROW OF DATA AFTER A BLANK CE Morton Detwyler[_2_] Excel Worksheet Functions 9 July 20th 08 05:56 PM
How do I delete blank rows (rows alternate data, blank, data, etc ncochrax Excel Discussion (Misc queries) 2 June 27th 07 04:40 AM
Copy rows of data (eliminating blank rows) from fixed layout Sweepea Excel Discussion (Misc queries) 1 March 13th 07 11:05 PM
Get number of rows that data takes up, including blank rows Denham Coote Excel Worksheet Functions 2 August 21st 06 09:18 AM
finding blank cell and moving specific data into it BeJay Excel Worksheet Functions 1 May 30th 06 07:06 PM


All times are GMT +1. The time now is 02:42 AM.

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

About Us

"It's about Microsoft Excel"