From mboxrd@z Thu Jan  1 00:00:00 1970
From: Bastien <bzg@altern.org>
Subject: Re: org table calc and lisp for hh:mm timetable
Date: Sat, 02 Jul 2011 13:38:30 +0200
Message-ID: <87aacwsyix.fsf@gnu.org>
References: <9999237C-1FBD-481E-AF8D-D68DB85080CE@gmail.com>
	<87lj0gqjd3.fsf@ucl.ac.uk>
	<0DDD90AF-9B9A-4FE3-8080-74EF01E6E292@gmail.com>
	<4D7FDE8C.1030103@christianmoe.com>
	<00BD91C6-C610-4CDD-B3E0-E9FECDAA372C@gmail.com>
	<87k4fynog3.fsf@altern.org> <87lj09llzd.fsf@gmail.com>
	<4D866AD7.4020701@christianmoe.com> <87fwqhl5mu.fsf@gmail.com>
	<87mxknhioh.fsf@gmail.com>
	<20D6527E-03EC-49E1-9751-4A042E65B3BD@gmail.com>
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 ([140.186.70.92]:49160)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <bastienguerry@googlemail.com>) id 1QcyWS-0003Gl-24
	for emacs-orgmode@gnu.org; Sat, 02 Jul 2011 07:38:05 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <bastienguerry@googlemail.com>) id 1QcyWR-0000wp-0l
	for emacs-orgmode@gnu.org; Sat, 02 Jul 2011 07:38:04 -0400
Received: from mail-fx0-f52.google.com ([209.85.161.52]:57568)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <bastienguerry@googlemail.com>) id 1QcyWQ-0000wf-SQ
	for emacs-orgmode@gnu.org; Sat, 02 Jul 2011 07:38:02 -0400
Received: by fxd18 with SMTP id 18so3539721fxd.39
	for <emacs-orgmode@gnu.org>; Sat, 02 Jul 2011 04:38:02 -0700 (PDT)
In-Reply-To: <20D6527E-03EC-49E1-9751-4A042E65B3BD@gmail.com> (Carsten
	Dominik's message of "Tue, 22 Mar 2011 11:52:56 +0100")
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: </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: Carsten Dominik <carsten.dominik@gmail.com>
Cc: emacs-orgmode@gnu.org, mail@christianmoe.com, Martin Halder <martin.halder@gmail.com>

Hi all,

Carsten Dominik <carsten.dominik@gmail.com> writes:

> How about introducing another flag for the formula to turn
> on time string processing like this? 

I've implemented this.

You can now use the "T" flag to compute durations:

| Task 1 | Task 2 |   Total |
|--------+--------+---------|
|  35:00 |  35:00 | 1:10:00 |
#+TBLFM: @2$3=$1+$2;T

The "T" flag works also for Elisp formulas.

| Task 1 | Task 2 |   Total |
|--------+--------+---------|
|  35:00 |  35:00 | 1:10:00 |
#+TBLFM: @2$3='(+ $1 $2);T

Time values must be of the form [HH:]MM:SS.

Thanks to everyone for ideas about this!   Of course, timestamp
manipulation is what comes next.  But please test this and report
any problem.

Best,

-- 
 Bastien