Jet Fusion
Member
Hi
How would I insert a formula to calculate the average of a range of data between given times eg between the hours 06:00 - 09:00 in the morning it should give an average of the data in B9:B52 and put it in C6 and so on. If C is done then it's a matter of copying and changing the times for the rest of the columns.
Thanks in advance (file attached)
How would I insert a formula to calculate the average of a range of data between given times eg between the hours 06:00 - 09:00 in the morning it should give an average of the data in B9:B52 and put it in C6 and so on. If C is done then it's a matter of copying and changing the times for the rest of the columns.
Thanks in advance (file attached)