assign data from time interval

[slegja]

Hello,

I have data for different time intervals for one month.

[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 500"]
<tbody>[TR]
[TD]Start Time[/TD]
[TD]End Time[/TD]
[TD]Value 1[/TD]
[TD]Value 2[/TD]
[/TR]
[TR]
[TD]1.1.2012 00:08[/TD]
[TD]1.1.2012 00:18[/TD]
[TD]12,3[/TD]
[TD]13,4[/TD]
[/TR]
[TR]
[TD]1.1.2012 00:18[/TD]
[TD]1.1.2012 00:29[/TD]
[TD]14,6[/TD]
[TD]12,5[/TD]
[/TR]
[TR]
[TD]1.1.2012 00:29[/TD]
[TD]1.1.2012 00:39[/TD]
[TD]8,7[/TD]
[TD]9,6[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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:
[TABLE="width: 500"]
<tbody>[TR]
[TD]aTIME[/TD]
[TD]aValue 1[/TD]
[TD]aValue 2[/TD]
[/TR]
[TR]
[TD]1.1.2012 00:16[/TD]
[TD]12,3[/TD]
[TD]13,4[/TD]
[/TR]
[TR]
[TD]1.1.2012 00:17[/TD]
[TD]12,3[/TD]
[TD]13,4[/TD]
[/TR]
[TR]
[TD]1.1.2012 00:18[/TD]
[TD]14,6[/TD]
[TD]12,5[/TD]
[/TR]
[TR]
[TD]1.1.2012 00:19[/TD]
[TD]14,6[/TD]
[TD]12,5[/TD]
[/TR]
</tbody>[/TABLE]

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>[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]I can't solve it.. I would really appreciate any help
Thanks! [/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[/TR]
</tbody>[/TABLE]