Add or subtract times in an org-table

Add or subtract times in an org-table

[Bastian Bechtold]

Hi,

I am an enthusiastic user of org-mode for organizing my work and
clocking my work time.

At the end of each week, I use org-agenda to view a summary of what I
worked on that week and how long I worked per project and in total. This
is great!

Then, I put this into an org-table that sums up the time I worked
against my quota like this:

| week |  time | quota |  diff | overtime | comments               |
|------+-------+-------+-------+----------+------------------------|
| W01  | 11:45 | 12:00 | -0:15 |    -0:15 |                        |
| W02  | 14:30 | 12:00 |  1:30 |     1:15 |                        |
| W03  |  9:00 |  9:36 | -0:36 |     0:39 | sick on friday (-2:24) |

Where the second column is the time I actually worked, the third column
is the time I should have worked, the fourth column is the difference
between the second and the third (i.e. overtime), and the fifth column
sums up the overtime over time.

The thing is, I do all this by hand because I can't figure out how to
add or subtract times in emacs.

Could any of you emacs wizards help me with that? Any hints would be
appreciated!

Kind regards,
Bastian

Re: Add or subtract times in an org-table

[Bastien]

Hi Bastian,

Bastian Bechtold <emacs@bastibe.de> writes:

> The thing is, I do all this by hand because I can't figure out how to
> add or subtract times in emacs.

See the formula at the bottom of this table:

| week |     time | quota |  diff | overtime | comments               |
|------+----------+-------+-------+----------+------------------------|
| W01  |    11:45 | 12:00 | -0:15 |    -0:15 |                        |
| W02  |    14:30 | 12:00 |  1:30 |     1:15 |                        |
| W03  |     9:00 |  9:36 | -0:36 |     0:39 | sick on friday (-2:24) |
|------+----------+-------+-------+----------+------------------------|
|      | 35:15:00 |       |       |          |                        |
#+TBLFM: @5$2=vsum(@2..@4);T

You can check this info node:

  (info "(org)Durations and time values")

> Could any of you emacs wizards help me with that? Any hints would be
> appreciated!

HTH,

-- 
 Bastien

Re: Add or subtract times in an org-table

[Bastian Bechtold]

Hi Bastien,

thank you very much for that answer! It pointed me in the perfect
direction and allowed me to solve my problem.

For the record, my solution is

| week |  time | quota |      diff |  overtime | comments               |
|------+-------+-------+-----------+-----------+------------------------|
| W01  | 11:45 | 12:00 | -00:15:00 | -00:15:00 |                        |
| W02  | 14:30 | 12:00 |  02:30:00 |  02:15:00 |                        |
| W03  |  9:00 |  9:36 | -00:36:00 |  01:39:00 | sick on friday (-2:24) |
#+TBLFM: $4=$2-$3;T::$5=@-1+$-1;T

Which calculates the correct results, albeit with some useless ':00'
seconds appended to every calculation.

Still, this solves my problem.

Thank you very much,
Bastian