how to compare times of events btwn worksheets
 

In worksheet 1, column A I have a long list (350K rows) of dates and times
of an event (namely when an ambulance goes enroute to the hospital..)

In worksheet 2 (8K rows) I have data from hospitals with times they are
unable to accept ambulances with column A (start date/time) and column B
(stop date/time)

My goal is this: In a new column (column B, worksheet 1) I need a formula
that creates a flag for every transport in worksheet 1 that occurs during any
time between Columns A and B in worksheet 2.

I can use "if" statements to analyse one row but I can't figure out how to
compare multiple rows...I'm using Excel 2007 for windows.

thanks

how to compare times of events btwn worksheets
 

Hi,

I'm not clear on you question, with 8000 rows on sheet2 each with a
different time? what are your time increments? 24*60 = 1440. Are you
tracking at the 10 second interval? Also since you have a start and an end
time which interval do you want reflected in sheet1, the start or the end?
Say it starts at 8:01 AM and ends at 11:37 AM (long ride) that would be
about 800 time slots it could fall into.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"daveg" wrote:

In worksheet 1, column A I have a long list (350K rows) of dates and times
of an event (namely when an ambulance goes enroute to the hospital..)

In worksheet 2 (8K rows) I have data from hospitals with times they are
unable to accept ambulances with column A (start date/time) and column B
(stop date/time)

My goal is this: In a new column (column B, worksheet 1) I need a formula
that creates a flag for every transport in worksheet 1 that occurs during any
time between Columns A and B in worksheet 2.

I can use "if" statements to analyse one row but I can't figure out how to
compare multiple rows...I'm using Excel 2007 for windows.

thanks