From mboxrd@z Thu Jan  1 00:00:00 1970
From: Richard Lawrence <richard.lawrence@berkeley.edu>
Subject: Re: Add time (duration) to timestamp
Date: Mon, 07 Dec 2015 09:56:26 -0800
Message-ID: <877fkquoqd.fsf@berkeley.edu>
References: <87twnuk73u.fsf@iki.fi> <87poyik4dv.fsf@iki.fi>
Mime-Version: 1.0
Content-Type: text/plain
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([2001:4830:134:3::10]:51586)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <richard.lawrence@berkeley.edu>) id 1a6017-0003is-GF
	for emacs-orgmode@gnu.org; Mon, 07 Dec 2015 12:56:06 -0500
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <richard.lawrence@berkeley.edu>) id 1a6014-0004od-1x
	for emacs-orgmode@gnu.org; Mon, 07 Dec 2015 12:56:05 -0500
Received: from mail-pf0-x22b.google.com ([2607:f8b0:400e:c00::22b]:35274)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <richard.lawrence@berkeley.edu>) id 1a6013-0004oY-S3
	for emacs-orgmode@gnu.org; Mon, 07 Dec 2015 12:56:01 -0500
Received: by pfu207 with SMTP id 207so68297071pfu.2
	for <emacs-orgmode@gnu.org>; Mon, 07 Dec 2015 09:56:01 -0800 (PST)
In-Reply-To: <87poyik4dv.fsf@iki.fi>
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
To: Jarmo Hurri <jarmo.hurri@iki.fi>, emacs-orgmode@gnu.org

Hi Jarmo,

Jarmo Hurri <jarmo.hurri@iki.fi> writes:

> Answering my own question, the following seems to work (15 min is 1/96
> of a day):
>
> | time                   | event |
> |------------------------+-------|
> | <2015-12-07 Mon 12:00> | A     |
> | <2015-12-07 Mon 12:15> | B     |
> | <2015-12-07 Mon 12:30> | C     |
> #+TBLFM: @3$1..@4$1=(<@-1>+(1.0 / 96))

Have you looked at Org's clocking features? (See "Clocking work time" in
the Dates and Times section of the manual.)

Clocking timestamps go into a drawer, rather than a table, but you can
generate a clock report table.  Depending on what you're trying to do,
that might be a cleaner and more flexible solution.

Best,
Richard