LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
KK KK is offline
external usenet poster
 
Posts: 4
Default Averaging an interval of data

Each hour is broken into 15 minute intervals. I'd like to average four
intervals in each hour. How do I do that?

There are many intervals so I need a quick solution, can't do it
manually.

Here's a screenshot of example data:

http://www.aww-kittah-aww.com/up/public/73735/xls.jpg
 
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
Grouping a Set of Data By Time Interval Jon[_5_] Excel Discussion (Misc queries) 2 September 14th 07 09:06 AM
averaging data James Excel Discussion (Misc queries) 10 December 11th 06 03:12 AM
How to plot categorical data to show confidence interval? Question... Excel Discussion (Misc queries) 0 April 26th 06 05:28 AM
Averaging data Capt Bill Excel Worksheet Functions 2 March 27th 06 10:13 AM
Averaging Values Embraced In an Interval Between Two Dates ChrisM Links and Linking in Excel 1 November 16th 05 12:25 AM


All times are GMT +1. The time now is 04:28 PM.

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

About Us

"It's about Microsoft Excel"