0

Windows 10, Emacs 26.1

|   | Start date       | End date         | Task     | State     | Duration (hours) |
|---+------------------+------------------+----------+-----------+------------------|
| # | 02.09.2019 15:30 | 02.09.2019 18:00 | INIT-124 | Postponed |             2.50 |
| # | 03.09.2019 10:30 | 03.09.2019 12:00 | INIT-124 | Taken     |             1.50 |
| # | 03.09.2019 13:00 | 03.09.2019 14:30 | INIT-124 | Done      |             1.50 |
| # | 03.09.2019 14:30 | 03.09.2019 18:00 | T-332    | Taken     |             3.50 |
| # | 04.09.2019 10:30 | 04.09.2019 12:00 | T-332    | Taken     |             1.50 |
| # | 04.09.2019 13:30 | 04.09.2019 18:00 | T-339    | Taken     |             4.50 |
| # | 05.09.2019 10:30 | 05.09.2019 12:00 | T-332    | Taken     |             1.50 |
| # | 05.09.2019 15:00 | 05.09.2019 16:30 | T-332    | Taken     |             1.50 |
| # | 05.09.2019 16:30 | 05.09.2019 18:30 | INIT-123 | Postponed |             2.00 |
| # | 06.09.2019 10:30 | 06.09.2019 12:00 | T-339    | Taken     |             1.50 |
| # | 06.09.2019 13:30 | 06.09.2019 15:30 | T-340    | Taken     |             2.00 |
| # | 06.09.2019 15:30 | 06.09.2019 18:00 | T-339    | Done      |             2.50 |
|---+------------------+------------------+----------+-----------+------------------|
|   |                  |                  |          |           |             8.50 |
#+TBLFM: $6=$3-$2;t::@>$6=vsum(subscr(@I..@II,{6,10,12}));%.2f

I want to calculate how many time I spend for task "T-339". To do this I use table formula with row numbers

#+TBLFM: $6=$3-$2;t::@>$6=vsum(subscr(@I..@II,{6,10,12}));%.2f

and result is 8.50

Nice it's correct result.

But to do this I need find all rows numbers (6,10,12). It's not very comfortable.

Is it possible to sum all hours (column Duration) not by rows number, but by task name (column Task, e.g. T-339) ?

Smt. like:

Sum column Duration in all rows that in column `Task = "T-339"`

Is it possible it org table?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.