I need to calculate the average temperature in a cycle of 30s, and my temperature log is taking one reading every 15 sec. I recorded cycle end time, and I would like to write script to calculate the average temperature during 30s prior to the cycle end time.
This isn't right, but I think you can get there by modifying the formulas I used in this table. I also think your example doesn't match what you are asking for. The averages you show in what you desire appear to be for all time readings within a minute of the cycle end time, not 30 seconds. Sorry, I don't script, but you can easily get the script from my attached table - but first, you'll need to modify the formulas to get exactly what you want.
cycle is 30 sec, for example, at 1:46pm, that's the end of cycle, so cycle start at 1:45:30pm, and same for cycle end time 1:48pm, the start time is 1:47:30pm, so any time between 1:46:00pm and 1:47:30, there is no cycle or no critical operation, which I don't need to average temperature at those time peroid.