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:
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
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 03:29 PM
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 09:24 PM.

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

About Us

"It's about Microsoft Excel"