View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Dave Curtis Dave Curtis is offline
external usenet poster
 
Posts: 100
Default formula to convert 15 minute to hourly data

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