Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 20th 10, 04:12 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2010
Posts: 457
Default 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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Is there a simple formula to convert time in hundredths to minute Ron Excel Worksheet Functions 11 January 19th 17 03:29 PM
formula to convert 15 minute to hourly data Emily New Users to Excel 7 September 22nd 16 10:17 AM
How to convert half hourly data into hourly kippers Excel Discussion (Misc queries) 5 February 1st 07 10:27 AM
convert angle minute to decimal nobbyknownowt Excel Discussion (Misc queries) 2 December 21st 06 07:37 PM
convert time from 60 minute hour to 100 minute hour Jboerding Excel Discussion (Misc queries) 2 July 6th 05 11:30 PM


All times are GMT +1. The time now is 11:59 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017