Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
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
formula to convert 15 minute to hourly data Emily New Users to Excel 8 April 3rd 23 02:12 PM
Is there a simple formula to convert time in hundredths to minute Ron Excel Worksheet Functions 11 January 19th 17 04:29 PM
How to convert half hourly data into hourly kippers Excel Discussion (Misc queries) 5 February 1st 07 11:27 AM
convert angle minute to decimal nobbyknownowt Excel Discussion (Misc queries) 2 December 21st 06 08: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 01:37 PM.

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

About Us

"It's about Microsoft Excel"