Moving Average Based On Time Period

DaveWW00

New Member
Joined
Feb 3, 2006
Messages
39
I have data from a datalogger which varies in the time interval it was collected, sometimes the data is collected every hour, sometimes every 15 minutes. Column A has date/time info (ex: 6/3/16 9:52:00) and Column B have the raw readings (ex: 0.00025). I would like to be able to create graph that is moving average over 24 hour period but with the varying time intervals i cant do this using the normal moving average trendline in the graphs and need a formula to do it in the table first and then graph that. I think the complicated part of this might be during the transitions from 15 minute to 1 hour readings and vice versa. Appreciate the help. Thanks!
 

Some videos you may like

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

Watch MrExcel Video

Forum statistics

Threads
1,100,205
Messages
5,473,152
Members
406,849
Latest member
AndreasMs

This Week's Hot Topics

Top