Moving Average Based On Time Period

[DaveWW00]

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!

 

[DaveWW00]

can anybody please help? there has to be way to do this. thanks!