Lookup with Hours and Minutes

[Peter00]

I believe this is just more of a syntax problem, but I'm trying to lookup a number based on the hour and minute it occured, but not the second.

=VLOOKUP(AND(HOUR(D3),MINUTE(D3)),A3:B16,2,FALSE)

The setup is that I have a machine that runs at a certain rate at each minute, and material gets fed into at different intervals, which last only a few seconds. I'm trying to determine how much material is being fed by multiplying run speed by run time. However, I need the lookup to have the right run speed for each run time.

I have attached a sample of the data.

Thanks in advance for your help,

Peter

[NBVC]

Perhaps:

=VLOOKUP(INT(D3)+TIME(HOUR(D3),MINUTE(D3),0),$A$3:$B$16,2,FALSE)

I have included the date, I assume if you have multiple dates, that it matters?

[Peter00]

Just made the range constant, but other than that, it's all good!

Thanks alot!

[NBVC]

If you want to base strictly on time, and the return values are numbers as per sample, then you can try:

=SUMPRODUCT(--(ROUND(MOD($A$3:$A$16,1),5)=ROUND(TIME(HOUR(D3),MINUTE(D3),0),5)),$B$3:$B$16)