I am trying to calculate the area under the curve on my Power-Time graph so that I can determine the energy.

Would anyone have an idea of how I can calculate the area under the curve? The solution would also have to ignore cells with #N/A. Would I also be able to choose a specific time range for this area?

Shown below is a very small sample of my data:

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 |

0.011250 | #N/A |

0.011267 | #N/A |

0.01 | #N/A |

0.01 | 4.09 |

0.01 | 4.01 |

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

</tbody>

Thanks,

David