A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

formula to convert 15 minute to hourly data

Thread Tools Display Modes
Old May 20th, 2010, 04:12 PM posted to microsoft.public.excel.newusers
Luke M[_4_]
external usenet poster
Posts: 451
Default formula to convert 15 minute to hourly data

This formula should work:
this averages range B2:B5
copying down will automatically change it to:
which averages range B5:B8

Best Regards,

Luke M
"penny" wrote in message news:...
X-Mailer: http://www.umailcampaign.com, ip log:
Newsgroups: microsoft.public.excel.newusers
NNTP-Posting-Host: 22.bb.5446.static.theplanet.com
Path: TK2MSFTNGP01.phx.gbl!TK2MSFTNGP04.phx.gbl!newspe.c om
Lines: 1
Xref: TK2MSFTNGP01.phx.gbl microsoft.public.excel.newusers:69083

I tried to use this and it works but how can I get the B2:B5 range to
at the ending cell (i.e. B5) and calculate each subsequent range
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
much appreciated. Thank you for taking the time to look at this.



Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

All times are GMT +1. The time now is 09:09 AM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 OfficeFrustration.
The comments are property of their posters.