[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Add or subtract times in an org-table

From: Bastian Bechtold
Subject: Add or subtract times in an org-table
Date: Tue, 12 Feb 2013 09:30:21 +0100
User-agent: mu4e 0.9.9; emacs 24.2.1


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

Kind regards,

reply via email to

[Prev in Thread] Current Thread [Next in Thread]