From mboxrd@z Thu Jan 1 00:00:00 1970 From: Eric S Fraga Subject: Re: funny remote time/duration values Date: Mon, 07 Jan 2019 11:58:32 +0000 Message-ID: <874laku1av.fsf@gmail.com> References: <20190107105827.77f240dc@lt70.mpip-mainz.mpg.de> Mime-Version: 1.0 Content-Type: text/plain Return-path: Received: from eggs.gnu.org ([209.51.188.92]:39846) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1ggTYC-0003Am-JS for emacs-orgmode@gnu.org; Mon, 07 Jan 2019 06:58:37 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1ggTYC-0007Ax-15 for emacs-orgmode@gnu.org; Mon, 07 Jan 2019 06:58:36 -0500 Received: from mail-wr1-x436.google.com ([2a00:1450:4864:20::436]:41167) by eggs.gnu.org with esmtps (TLS1.0:RSA_AES_128_CBC_SHA1:16) (Exim 4.71) (envelope-from ) id 1ggTYB-000799-Qi for emacs-orgmode@gnu.org; Mon, 07 Jan 2019 06:58:35 -0500 Received: by mail-wr1-x436.google.com with SMTP id x10so110485wrs.8 for ; Mon, 07 Jan 2019 03:58:35 -0800 (PST) In-Reply-To: <20190107105827.77f240dc@lt70.mpip-mainz.mpg.de> (Robert Klein's message of "Mon, 7 Jan 2019 10:58:27 +0100") 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" To: Robert Klein Cc: "emacs-orgmode@gnu.org" On Monday, 7 Jan 2019 at 10:58, Robert Klein wrote: > Hi, > > when using values (time/duration) from a remote table I sometimes get > funny values: > > #+name: teta > | 4:50 | > > | 2:25 | > #+TBLFM: @1$1=remote(teta,@1$1) Note that x:y in Emacs calc (which is what org uses for the spreadsheet elements of tables) is a ratio so 4:50 *is* the same as 2:25. If you have times, you'll need to use different notation (@,',", I believe). -- Eric S Fraga via Emacs 27.0.50, Org release_9.1.14-1035-gfeb442