Hi there,
I need to convert my 5 min interval data into 30 mins by adding up all the 5 min values in the 30 min time slot.
Eg. The 6 highlighted values in column D need to sum in column J. Note: I will add up the values for column D2 to D6 myself as its not a complete 30 mins.
I need to convert my 5 min interval data into 30 mins by adding up all the 5 min values in the 30 min time slot.
Eg. The 6 highlighted values in column D need to sum in column J. Note: I will add up the values for column D2 to D6 myself as its not a complete 30 mins.