Hi,
Given the following data from your spreadsheet , how do you want it
changed? Like Robert, I am struggling to see how you want it formatted.

Cumulative
Time 15 minute
intervals Voltage of turn.
0:00:00 00:00:00 -0.06
0:18:44 00:15:00 5.02
0:18:45 00:30:00 -0.02
1:16:59 00:45:00 2.52
1:17:00 01:00:00 -0.04


"A S-D" wrote:


Thank you for your consideration, Robert111.

I don't know what a vlookup table is, I'm afraid.

Let me try to explain a little clearer, as I think your solution falls
into problems when an interval would have no entries.

I have data from a device. This device records the RApid Turn of some
apparatus, through a varying voltage. Each time the voltage changes
(i.e. the device detects a turn) an entry is made with the appropriate
timestamp from time zero which is the start of the recording.

So..

-5.00 Volts 02:56:41
0.00 Volts 02:56:44
+5.00 Volts 02:57:03

I want to separate my data into 15 minute blocks, relative to the
start. How do I make it so that the timestamp maps itself to the 15
minute intervals? In some intervals, there was no activity at all, so
that interval should have no corresponding timestamps.

Is this even possible in Excel?


--
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