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:
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:, ip log:
Newsgroups: microsoft.public.excel.newusers
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 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 04: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 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 02:32 AM.

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

About Us

"It's about Microsoft Excel"


Copyright © 2017