Averaging Values Embraced In an Interval Between Two Dates
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
|