From mboxrd@z Thu Jan  1 00:00:00 1970
From: =?utf-8?B?xaB0xJtww6FuIE7Em21lYw==?= <stepnem@gmail.com>
Subject: Re: [BUG] Table formula with org-hh:mm-string-to-minutes
Date: Tue, 05 Oct 2010 20:13:37 +0200
Message-ID: <87ocb81p9q.fsf@gmail.com>
References: <87fwwkyc46.fsf@mundaneum.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from [140.186.70.92] (port=39756 helo=eggs.gnu.org)
	by lists.gnu.org with esmtp (Exim 4.43) id 1P3C2c-0007ZJ-MJ
	for emacs-orgmode@gnu.org; Tue, 05 Oct 2010 14:15:07 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <public@plane.gmane.org>) id 1P3C2b-0006tw-En
	for emacs-orgmode@gnu.org; Tue, 05 Oct 2010 14:15:06 -0400
Received: from plane.gmane.org ([80.91.229.3]:42566)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <public@plane.gmane.org>) id 1P3C2b-0006td-8e
	for emacs-orgmode@gnu.org; Tue, 05 Oct 2010 14:15:05 -0400
Received: from public by plane.gmane.org with local (Exim 4.69)
	(envelope-from <public@plane.gmane.org>) id 1P3C2W-000064-NM
	for emacs-orgmode@gnu.org; Tue, 05 Oct 2010 20:15:00 +0200
In-Reply-To: <87fwwkyc46.fsf@mundaneum.com> (=?utf-8?Q?=22S=C3=A9bastien?=
	Vauban"'s message of "Tue, 05 Oct 2010 15:59:05 +0200")
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <http://lists.gnu.org/mailman/listinfo/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: <http://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
To: =?utf-8?Q?S=C3=A9bastien?= Vauban <public-wxhgmqzgwmuf-geNee64TY+gS+FvcfC7Uqw@plane.gmane.org>
Cc: public-emacs-orgmode-mXXj517/zsQ@plane.gmane.org



S=C3=A9bastien Vauban <wxhgmqzgwmuf-geNee64TY+gS+FvcfC7Uqw@public.gmane.org>
writes:

> Hello,
>
> I use the following table and formulas to convert HH:MM times to fraction=
al
> times, so that I can sum up the times (and convert them to money...)
>
> | Task   | *HH:MM* | *Frac* |
> |--------+---------+--------|
> | Item 1 |   20:27 |  20.45 |
> | Item 2 |    2:25 |   2.42 |
> | Item 3 |    2:07 |   2.12 |
> | Item 4 |    0:19 |   0.00 |
> | Item 5 |    0:43 |   0.72 |
> | Item 6 |    0:05 |   0.08 |
> | Item 7 |    0:32 |   0.53 |
> | Item 8 |    0:16 |   0.27 |
> |--------+---------+--------|
> |        |         |  26.59 |
> #+TBLFM: $3=3D'(/ (float (org-hh:mm-string-to-minutes $2))
> 60.);%.2f::@5$3=3D0.00;%.2f::@10$3=3Dvsum(@-I..@-II)

I don't really understand Calc and Org table formulas, but the
"%.2f::@5$3=3D0.00;" in there looks pretty suspicious, and removing it
fixes it for me. ;-)

=C5=A0t=C4=9Bp=C3=A1n