I was wondering how to write a function to search a column for one time, a second time and average everything in the next cell in between. Here would be an example
A B C
Time Number Average
0:00.00 3 =timeAvg(A, 0:00.00, 1:00.00, B) [this would output 3.33]
0:01.15 3 =timeAvg(A, 1:00.00, 2:00.00, B) [this would output 2.5]
0:10.2 4 =tiimeAvg(A, 2:00.00, 3:00.00, B) [this would output 2]
1:00.00 2
1:15.0 3
2:05.00 2
2:13.3 1
2:30.5 3
3:00.00 35
OK I know this probably looks crappy but if you can try to decipher it A2 says 0:00.00, B2 says 3, and B3 says =timeAvg(A, 0:00.00, 1:00.00, B) [this would output 3.33]. Everything column is separated by a space. If there is a better way to post this let me know.
I don't know if this can even be done, but what as you can see it takes all
times that include the first time (if it is in the column) but are less than (not including) the second time that are in the first column in and averages the numbers from the second column.
Is this possible???
Thanks
Chris
Bookmarks