Hi all,

My spreadsheet contains a matrix of data in four columns by approximately
600 rows. The data is structured as follows:

column A = start date
column B = start time
column c = stop date
column d = stop time

Each one of the 600 hundred rows contains a different set of start/stop
information.

I have another spreadsheet which lists meteorological information over this
same time period. The data in this spreadheet is structured as follows:

column A = date
columns c through AB = time (0:00 - 24:00)

Basically, I am looking for a program to read the start and stop information
from columns A, B, C and D of spreadsheet 1 and output an average of the
meteorological values (eg. temperature) corresponding to this time interval.
Is there a function in Excel or some code in Visual Basic that can handle
this task for me??

I am thinking it may have to include the Datediff function but am not sure??

Any suggestions would be greatly appreciated.

Chris