Hi all:
I am having an issue on some data collection that I was hoping I could receive some assistance on.
I have a data collector that checks the temperature of a piece of machinery in my plant 4 times per second. The machinery goes in cycles which create a curve in temperature going down. In order to check the control of the procedure, I would like to find the average temperature per minute. The report I get has one column for time with a format of (6/28/17 10:20:04.000) and so on as the time changes. The next column is the temperature.
I have made a column with cells with minute intervals (6/28/17 10:20:00.000, 6/28/17 10:21:00.000, etc.)
I would like to make a formula that says to average all numbers in column B where column A is between 10:20 and 10:21 and so on and so forth. I've tried various forms of AverageIfs and AverageIf to no avail. Any help with this would be greatly appreciated.
Thank you
I am having an issue on some data collection that I was hoping I could receive some assistance on.
I have a data collector that checks the temperature of a piece of machinery in my plant 4 times per second. The machinery goes in cycles which create a curve in temperature going down. In order to check the control of the procedure, I would like to find the average temperature per minute. The report I get has one column for time with a format of (6/28/17 10:20:04.000) and so on as the time changes. The next column is the temperature.
I have made a column with cells with minute intervals (6/28/17 10:20:00.000, 6/28/17 10:21:00.000, etc.)
I would like to make a formula that says to average all numbers in column B where column A is between 10:20 and 10:21 and so on and so forth. I've tried various forms of AverageIfs and AverageIf to no avail. Any help with this would be greatly appreciated.
Thank you