Time Series Analysis VBA Transformation

[WillRust]

Hello!

I have data from two water pumps - the data is given in start/stop times for the pump activation.
So in column A I have dd/mm/yyyy hh:mm:ss and in column B; then "Start"/"Stop". So something like this for each pump...

[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 230"]
<tbody>[TR]
[TD]30-Jul-11 01:22:42[/TD]
[TD]RUNNING[/TD]
[/TR]
[TR]
[TD]30-Jul-11 01:28:20[/TD]
[TD]STOPPED[/TD]
[/TR]
[TR]
[TD]30-Jul-11 05:46:39[/TD]
[TD]RUNNING[/TD]
[/TR]
[TR]
[TD]30-Jul-11 05:53:04[/TD]
[TD]STOPPED[/TD]
[/TR]
[TR]
[TD]30-Jul-11 07:09:30[/TD]
[TD]RUNNING[/TD]
[/TR]
[TR]
[TD]30-Jul-11 07:17:21[/TD]
[TD]STOPPED[/TD]
[/TR]
[TR]
[TD]30-Jul-11 08:04:34[/TD]
[TD]RUNNING[/TD]
[/TR]
[TR]
[TD]30-Jul-11 08:16:19[/TD]
[TD]STOPPED[/TD]
[/TR]
[TR]
[TD]30-Jul-11 08:58:56[/TD]
[TD]RUNNING[/TD]
[/TR]
[TR]
[TD]30-Jul-11 09:13:55[/TD]
[TD]STOPPED[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]


I have this for two pumps (Pump A and Pump B) - each pump has its own pumping rate (Pump Rate A and Pump Rate B) (in litres / second) and in addition, when both pumps in operation at the same time, they pump with another pump rate (Pump Rate C).

Essentially I need to transform this data into a time series where each discrete time unit either has, Pump rate A, Pump Rate B, Pump Rate C or No Pump Active.

I also need a way of summing the total pumped volume between a given time period each day - so for the data available the total cumulative VOLUME (i.e. litres) pumped at each individual pump rate between 1am and 5am (or whatever time period is specified).

Any help / ideas would be much appreciated!!!

Cheers,
Will