Average Values Over Specific Time Ranges

[davyj93]

Hi guys,

I would like to calculate the average power over a specified time range. I could use the average function. However, the time increments are not consistent. As you can see in the table, the time increments vary. I think that the average function would assume that each time row is equally spaced.

Is there a formula that I could use to calculate the power over a specific time range (e.g. 0.002383 - 0.008500 mins)? You can also see that a number of cells have #N/A and therefore the formula will need to ignore these cells.

Would a area under graph formula need to be used? If so, what formula would be required?

Below is a very small sample of my table:

Time	Engine Power
(min)	(kW)
0.000000	#N/A
0.000383	4.04
0.001017	4.12
0.001033	#N/A
0.001700	#N/A
0.001717	#N/A
0.002350	#N/A
0.002383	4.09
0.003067	4.09
0.003083	#N/A
0.003917	#N/A
0.003933	#N/A
0.004433	4.13
0.004967	#N/A
0.004983	#N/A
0.005517	4.06
0.005533	#N/A
0.005933	#N/A
0.005950	#N/A
0.006483	4.02
0.006967	#N/A
0.006983	#N/A
0.007433	4.09
0.007450	#N/A
0.007967	4.05
0.008500	4.09
0.008933	#N/A
0.008950	#N/A
0.009417	#N/A
0.009433	#N/A
0.009917	4.05
0.009933	#N/A
0.010550	#N/A
0.010567	#N/A

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

Thanks,
David