[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 |
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
- Add or subtract times in an org-table,
Bastian Bechtold <=