From: Shelagh Manton <shelagh.manton@gmail.com>
To: help-gnu-emacs@gnu.org
Subject: Re: org-mode time spreadsheet
Date: Sat, 10 Jan 2009 02:22:58 +0000 (UTC) [thread overview]
Message-ID: <gk90q1$1ts$1@ger.gmane.org> (raw)
In-Reply-To: fb9694e9-2c48-478c-aa38-420ad3b8145c@s9g2000prm.googlegroups.com
On Fri, 09 Jan 2009 00:09:16 -0800, Deniz Dogan wrote:
> I hope this formats well, because I'm posting this through Google
> Groups... Anyways...
>
> Hi
>
> I'm trying to have an org-mode table which shows a working day (not
> necessarily every normal work day, I enter these myself) and when I got
> in, when I went out to lunch, when I came back, and when I left for the
> day. I want the last column "TOT" to display how long I was at work
> minus the time I was out for lunch.
>
> I'm well aware of timeclock-in, timeclock-out, as well as org-mode's C-
> c C-x C-i/C-o functionality, but I really want to have it as a
> spreadsheet. However, it seems that calc isn't that good at working with
> times, so now I'm asking you for help. Is this possible to do with plain
> org-mode? If so, what am I doing wrong? Below is the file I'm currently
> using and it seems that it doesn't realize that the values are actually
> timestamps.
>
> | DATE | IN | LUNCH FROM | LUNCH TO | OUT | TOT |
> |------------+-------+------------+----------+-------+--------| | THU 18
> NOV | 9:30 | 12:30 | 13:40 | 14:20 | 2:5 | | FRI 31 DEC |
> 10:00 | 12:00 | 14:00 | 16:00 | #ERROR | | SAT 1 JAN | 8:00 |
> 12:00 | 12:30 | 16:00 | #ERROR | | MON 5 JAN | 9:00 |
> 12:45 | 13:15 | 16:00 | #ERROR | | TUE 6 JAN | 16:30 | 17:30 |
> 18:30 | 22:30 | 1:5 | | WED 7 JAN | 9:00 | 12:00 | 12:40
> | 20:45 | 11:05 | | THU 8 JAN | 12:30 | 15:00 | 15:40 | 18:30
> | | | FRI 9 JAN | 9:00 | | | |
> | #+TBLFM: $6=$5-$2
>
> Deniz
If you use the notation for time that calc expects the calculations will
work.
ie instead of 10:15 use 10@ 15' or even 10h 15m
Shelagh
next prev parent reply other threads:[~2009-01-10 2:22 UTC|newest]
Thread overview: 3+ messages / expand[flat|nested] mbox.gz Atom feed top
2009-01-09 8:09 org-mode time spreadsheet Deniz Dogan
2009-01-10 2:22 ` Shelagh Manton [this message]
[not found] ` <mailman.4468.1231554193.26697.help-gnu-emacs@gnu.org>
2009-01-14 15:46 ` Deniz Dogan
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
Avoid top-posting and favor interleaved quoting:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to='gk90q1$1ts$1@ger.gmane.org' \
--to=shelagh.manton@gmail.com \
--cc=help-gnu-emacs@gnu.org \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* If your mail client supports setting the In-Reply-To header
via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line
before the message body.
Code repositories for project(s) associated with this external index
https://git.savannah.gnu.org/cgit/emacs.git
https://git.savannah.gnu.org/cgit/emacs/org-mode.git
This is an external index of several public inboxes,
see mirroring instructions on how to clone and mirror
all data and code used by this external index.