assign data from time interval

[slegja]

Hello,

I have data for different time intervals for one month.

Start Time End Time Value 1 Value 2 1.1.2012 00:08 1.1.2012 00:18 12,3 13,4 1.1.2012 00:18 1.1.2012 00:29 14,6 12,5 1.1.2012 00:29 1.1.2012 00:39 8,7 9,6 <tbody> </tbody> <tbody> </tbody> etc. I want to create new table with 1 minute intervals and assign proper Value1 and Value 2 to every minute. However, I'm not good in using Excel yet. I tried to use IF and LOOKUP functions, but I wasn't able tu use it properly in this case. I need to create table like this: aTIME aValue 1 aValue 2 1.1.2012 00:16 12,3 13,4 1.1.2012 00:17 12,3 13,4 1.1.2012 00:18 14,6 12,5 1.1.2012 00:19 14,6 12,5 <tbody> </tbody> I think, i need something like IF(aTIME>=Start Time AND aTIME<end time)="" in="" one="" row THEN aValue 1=Value1 AND aValue2=Value2</end>
I can't solve it.. I would really appreciate any help Thanks!

<tbody>
</tbody>