Hi,
The following seems to work even if there is missing data.
Assuming your data starts in row 2, enter the following formula in C2 and
drag down
=IF(MOD(ROW()+2,4)=0,VLOOKUP(ROUNDDOWN(A2*24,0)/24,$A$2:$B$10,2),"")
and the following formula in D2 and drag down
=IF(MOD(ROW()+2,4)=0,AVERAGE(B2:B5),"")
Dave
url:
http://www.ureader.com/msg/10356248.aspx