[VBA / Excel] Score expressions and SUM them
Posted on 2004-09-12
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.
 Button A21 enabled
 Machine running
 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!