Hello,
I have data for different time intervals for one month.
<tbody>
</tbody>
I have data for different time intervals for one month.
<tbody> </tbody> 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:
<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>