Hello,
I have some data that has been recording values every 3 minutes. However due to computer error some of the recordings are taken every 2,4 or even 20 minutes in some cases. The vast majority however are taken over 3 minutes.
What I would like to acheive is to be able to record and sum the value for every 30 minutes.
Is there a formula or any other way I would be able to do this for large datasets?
Please see a snapshot of the data below.
Any help is much appreciated.
Cheers
Charlie
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
I have some data that has been recording values every 3 minutes. However due to computer error some of the recordings are taken every 2,4 or even 20 minutes in some cases. The vast majority however are taken over 3 minutes.
What I would like to acheive is to be able to record and sum the value for every 30 minutes.
Is there a formula or any other way I would be able to do this for large datasets?
Please see a snapshot of the data below.
Any help is much appreciated.
Cheers
Charlie
Date | Time between reading | Minutes | Value |
17/12/14 | 0 | ||
17/12/14 | 00:04:00 | 4 | 0 |
17/12/14 | 00:03:00 | 3 | 0 |
17/12/14 | 00:03:00 | 3 | 0 |
17/12/14 | 00:03:00 | 3 | 0 |
17/12/14 | 00:03:00 | 3 | 0 |
17/12/14 | 00:03:00 | 3 | 0 |
17/12/14 | 00:03:00 | 3 | 0 |
17/12/14 | 00:04:00 | 4 | 0 |
17/12/14 | 00:03:00 | 3 | 0 |
17/12/14 | 00:03:00 | 3 | 0 |
17/12/14 | 00:04:00 | 4 | 0 |
17/12/14 | 00:03:00 | 3 | 0 |
17/12/14 | 00:04:00 | 4 | 0 |
17/12/14 | 00:03:00 | 3 | 0 |
17/12/14 | 00:03:00 | 3 | 0 |
17/12/14 | 00:04:00 | 4 | 0 |
17/12/14 | 00:03:00 | 3 | 0 |
17/12/14 | 00:03:00 | 3 | 0 |
17/12/14 | 00:03:00 | 3 | 0 |
17/12/14 | 00:03:00 | 3 | 0 |
17/12/14 | 00:04:00 | 4 | 0 |
17/12/14 | 00:03:00 | 3 | 0 |
17/12/14 | 00:03:00 | 3 | 0 |
17/12/14 | 00:03:00 | 3 | 0 |
17/12/14 | 00:03:00 | 3 | 0 |
17/12/14 | 00:03:00 | 3 | 0 |
17/12/14 | 00:04:00 | 4 | 0 |
17/12/14 | 00:03:00 | 3 | 0 |
17/12/14 | 00:03:00 | 3 | 0 |
17/12/14 | 00:03:00 | 3 | 0 |
17/12/14 | 00:03:00 | 3 | 0 |
17/12/14 | 00:03:00 | 3 | 0 |
17/12/14 | 00:03:00 | 3 | 0 |
17/12/14 | 00:04:00 | 4 | 0 |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>