From mboxrd@z Thu Jan 1 00:00:00 1970 From: Michal Politowski Subject: Re: funny remote time/duration values Date: Mon, 7 Jan 2019 13:08:05 +0100 Message-ID: <20190107120805.GB31623@meep.pl> References: <20190107112915.74afa31b@lt70.mpip-mainz.mpg.de> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Return-path: Received: from eggs.gnu.org ([209.51.188.92]:42607) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1ggThl-0005l1-NK for emacs-orgmode@gnu.org; Mon, 07 Jan 2019 07:08:30 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1ggThl-0002zG-2D for emacs-orgmode@gnu.org; Mon, 07 Jan 2019 07:08:29 -0500 Received: from mx1.icm.edu.pl ([213.135.59.49]:42872) by eggs.gnu.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:32) (Exim 4.71) (envelope-from ) id 1ggThk-0002vd-S5 for emacs-orgmode@gnu.org; Mon, 07 Jan 2019 07:08:29 -0500 Received: from smtp.icm.edu.pl (mail.icm.edu.pl [213.135.59.43]) by mx1.icm.edu.pl (Postfix) with ESMTP for ; Mon, 7 Jan 2019 13:08:08 +0100 (CET) Received: from Amber.meep.pl (87-207-126-16.dynamic.chello.pl [87.207.126.16]) by smtp.icm.edu.pl (Postfix) with ESMTPSA id 637431FC5B for ; Mon, 7 Jan 2019 13:08:08 +0100 (CET) Received: from mike by Amber.meep.pl with local (Exim 4.92-RC4) (envelope-from ) id 1ggThN-0001Kz-PU for emacs-orgmode@gnu.org; Mon, 07 Jan 2019 13:08:05 +0100 Content-Disposition: inline In-Reply-To: <20190107112915.74afa31b@lt70.mpip-mainz.mpg.de> List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Sender: "Emacs-orgmode" Cc: emacs-orgmode@gnu.org On Mon, 7 Jan 2019 11:29:15 +0100, Robert Klein wrote: >=20 > Hi, >=20 > when using values (time/duration) from a remote table I sometimes get > funny values: >=20 >=20 > #+name: teta > | 4:50 | >=20 >=20 > | 2:25 | > #+TBLFM: @1$1=3Dremote(teta,@1$1) >=20 >=20 > When I set e.g. 7:50 in =E2=80=9Cteta=E2=80=9D the same value shows up in= the second > table (after C-u C-c C-c). >=20 > For 1:00 in =E2=80=9Cteta=E2=80=9D I get #ERROR in the second table. sam= e in all cases > with a 0 in front (04:50, 07:50, 01:00). >=20 >=20 > Org-version is 9.2 >=20 > Any ideas? It seems you need the 'T' flag here, as described in "Duration and time values" in the org manual: #+TBLFM: @1$1=3Dremote(teta,@1$1);T --=20 Micha=C5=82 Politowski