20081217 1202 GMT-5
I have columns E,G,I,K,and M.
In each one there is a start time, a finish time and a sumed number.
Example:
e540 = 240
e541 = 11:12
e542 = 11:28
e543 = 00:16 -> elapsed time
g540 = 240
g541 = 11:42
g542 = 12:00
g543 = 00:18
and so on
Now I have another area like this:
g545 = 480 -> total running of g540
g546 = 00:34 -> total running of e543
g547 = this equals total time (g541 - m542 = total time)
So this is what I would like to do. Since not all five columns are used
every time I would like to have something that sums what is there.
For example: today only three columns were used so I would like to take
E541-I542 instead of E541-M542.
To me this sounds complicated using this spread sheet but, since I have
to do this 15 or so times a day I would like to have some code that can
help me out.
Wade
--
Registered Linux User: #480675
Linux since June 2005
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
