Solved

# [VBA / Excel] Score expressions and SUM them

Posted on 2004-09-12

Hello,

I would like my code to do the following:

1 | 00:03 | EXPR A

2 | 00:10 | EXPR C

3 | 00:51 | EXPR B

4 | 00:49 | EXPR A

5 | 00:11 | EXPR C

6 | 01:16 | EXPR C

7 | 00:01 | EXPR A

The code should 'score' when e.g. EXPR A is used and

sum the time, which has a link with EXPR A (on same row)

The result, in this case, should be:

EXPR A: 00:53

EXPR B: 00:51

EXPR C: 01:37

In my application many expressions are used, 100 in total.

In expressions an index ( [integer] ) is included, which

perhaps can be used in the code.

Sample expressions:

[20] Button A21 enabled

[33] Machine running

[67] Machine off

I hope it is possible that a piece of code can sum the period

of time of expressions. I hope somebody knows the answer!

Thank you very much in advance!