# How to apply a 30 second moving average to data with inconsistent time intervals

1. ## How to apply a 30 second moving average to data with inconsistent time intervals

Hello,

Many thanks in advance to all those who use this site as it has saved me so much time in the past!

My current problem hopefully has a simple answer but is currently beyond my excel level. I am using Excel 2010 and wish to create a column that produces a MOVING 30 SECOND AVERAGE. My issue is that my time data (in seconds) is not consistently spaced (e.g. 2, 5, 6, 7, 10 etc) and therefore cannot apply an average over a constant number of cells. I will try to include an example data sheet so hopefully that will make things clearer where I have been vague.

Andy

2. ## Re: How to apply a 30 second moving average to data with inconsistent time intervals

Hi.
I am not sure
=SUM(OFFSET(B3,0,0,MATCH(A3+30,A3:A119,1),1))/COUNT(OFFSET(B3,0,0,MATCH(A3+30,A3:A119,1),1))

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1