Hi all,
I'm stuck with following problem;
Data set out as follows
Col A Col B
06:15 1
06:15 2
06:15 3
06:16 4
06:16 5
06:17 6
...
07:15 392
07:15 393
...
14:15 1198
I'm looking to use a formula that will give me the difference in the value in column B between two time periods in column A. The time period is the first 06:15 to the first 07:15 then in the next cell the same but between 07:15 and 08:15. I've been thinking along the lines of a sumproduct formula possibly?
Outputted values will be 06:15 to 07:15 392, 07:15 to 08:15 350 etc.
I'm stuck with following problem;
Data set out as follows
Col A Col B
06:15 1
06:15 2
06:15 3
06:16 4
06:16 5
06:17 6
...
07:15 392
07:15 393
...
14:15 1198
I'm looking to use a formula that will give me the difference in the value in column B between two time periods in column A. The time period is the first 06:15 to the first 07:15 then in the next cell the same but between 07:15 and 08:15. I've been thinking along the lines of a sumproduct formula possibly?
Outputted values will be 06:15 to 07:15 392, 07:15 to 08:15 350 etc.
