Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
ChrisM
 
Posts: n/a
Default Averaging Values between Two Dates/Times

Hi All,

I have a spreadsheet that contains 4 columns. Column A = start date, Column
B = Start Time, Column C = Stop Date, Column D = Stop Time.

I have another spreadsheet which contains meteorological data for a given
time period. The data in this spreadsheet lists the Date in cells A1 through
A(n) (eg.
Jan 1, 2005 to March 1, 2005). Columns C through AB list the time (0:00 to
23:00) corresponding to the date from column A. So the data looks like a
large matrix with dates listed in the rows of column A and 24 hour times
listed in columns C to AB.

Basically, I am looking for a function in Excel or a program in VBA to read
the start date and time and the stop date and time from the first
spreadsheet and then return an average value corresponding to those met
values that were embraced within the day/time interval on the second
spreadsheet. Is this possible or not???

Any help would be greatly appreciated as I am very lost.

Thanks

Chris


Reply
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
Using Match function with duplicate values in an array Richard Excel Worksheet Functions 3 April 22nd 23 07:45 PM
Averaging Values between Two Dates/Times ChrisM New Users to Excel 2 November 16th 05 04:16 AM
Averaging Values in Auto Filter Mr. Jan Park Excel Worksheet Functions 1 August 3rd 05 03:51 PM
Count Intervals of Filtered TEXT values in Column and Return Count across a Row Sam via OfficeKB.com Excel Worksheet Functions 9 July 31st 05 03:37 AM
Averaging selected values Hellion Excel Worksheet Functions 3 July 4th 05 03:29 AM


All times are GMT +1. The time now is 11:37 PM.

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"