Let us say there are three columns: A, B, and C.
Column A contains time formatted to [hh]:mm:ss and goes from 0:00:00 to
21:20:00. There are an arbitrary number of entries in this column.
Column B contains time formatted to [hh]:mm:ss and starts from 0:00:00
and ends at 21:30:00. -It increases in 15 minute intervals exactly.-
Column C contains data that is attached to Column A on the same row.
What I want is to make it that Column A's values match themselves to
Column B's values. I.E. For values of A between 00:00:00 and Column B
row 2 (00:15:00) I want the values of A (and therefore C) to line up
next to Column B row entry 00:00:00.
This isn't a very clear explanation. I will explain it again, and maybe
you can piece together what I mean.
There are many columns: Cumulative Time, 15 Minute Intervals and
several columns attached to the Cumulative Time column. The cumulative
time column is effectively a timestamp.
I want to sort my data so that the data values timestamped between,
say, 0 minutes and 15 minues will be together. The problem is, some 15
minute intervals have no entries, so I want a blank in the Cumulative
Time column next to the 15 minute interval which contains no time
points.
I will attach the spreadsheet. The columns of interest are B
(Cumulative Time) and C (15 minute intervals). All the other columns
should be associated with column A.
This will allow me to make 15 minute averages of my data (the columns N
to Q).
Thank you in advance. I really hope someone can help me, because this
problem has me really stumped. As you can see from the spreadsheet,
I've been tortuously grappling with this problem for a while!
Thanks,
Adam
+-------------------------------------------------------------------+
|Filename: Test Rat 080206-090206 Complete.zip |
|Download:
http://www.excelforum.com/attachment.php?postid=4592 |
+-------------------------------------------------------------------+
--
A S-D
------------------------------------------------------------------------
A S-D's Profile:
http://www.excelforum.com/member.php...o&userid=33227
View this thread:
http://www.excelforum.com/showthread...hreadid=530452