If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
formula to convert 15 minute to hourly data
This formula should work:
=AVERAGE(OFFSET($B$2,(ROW(A1)-1)*3,,4)) this averages range B2:B5 copying down will automatically change it to: =AVERAGE(OFFSET($B$2,(ROW(A2)-1)*3,,4)) which averages range B5:B8 -- Best Regards, Luke M "penny" wrote in message news:... Message-ID: X-Mailer: http://www.umailcampaign.com, ip log:68.45.155.120 Newsgroups: microsoft.public.excel.newusers NNTP-Posting-Host: 22.bb.5446.static.theplanet.com 70.84.187.34 Path: TK2MSFTNGP01.phx.gbl!TK2MSFTNGP04.phx.gbl!newspe.c om Lines: 1 Xref: TK2MSFTNGP01.phx.gbl microsoft.public.excel.newusers:69083 Hi, I tried to use this and it works but how can I get the B2:B5 range to begin at the ending cell (i.e. B5) and calculate each subsequent range accordingly. My problem is that if I am averaging every 15 minute data for each hour I would like for it to calculate B2:B5, B5:B8, B8:B11,etc...Any help would be much appreciated. Thank you for taking the time to look at this. url:http://www.ureader.com/msg/10356248.aspx |
Thread Tools | |
Display Modes | |
|
|