From mboxrd@z Thu Jan  1 00:00:00 1970
From: "Fraga, Eric" <e.fraga@ucl.ac.uk>
Subject: Re: Adding times in a table
Date: Sun, 22 Sep 2019 16:46:23 +0000
Message-ID: <8736goqnxd.fsf@ucl.ac.uk>
References: <mailman.41.1569081606.23821.emacs-orgmode@gnu.org>
 <4b015484-3492-14af-9d0b-0dd56dc27f4d@gmx.fr>
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([2001:470:142:3::10]:56256)
 by lists.gnu.org with esmtp (Exim 4.90_1)
 (envelope-from <e.fraga@ucl.ac.uk>) id 1iC50F-0008Tv-Rc
 for emacs-orgmode@gnu.org; Sun, 22 Sep 2019 12:46:28 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
 (envelope-from <e.fraga@ucl.ac.uk>) id 1iC50E-0004d7-PW
 for emacs-orgmode@gnu.org; Sun, 22 Sep 2019 12:46:27 -0400
Received: from mail-eopbgr70095.outbound.protection.outlook.com
 ([40.107.7.95]:42244 helo=EUR04-HE1-obe.outbound.protection.outlook.com)
 by eggs.gnu.org with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:32)
 (Exim 4.71) (envelope-from <e.fraga@ucl.ac.uk>) id 1iC50E-0004cR-Eg
 for emacs-orgmode@gnu.org; Sun, 22 Sep 2019 12:46:26 -0400
Content-Language: en-US
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: <https://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"
 <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
To: gmx <fredstev@gmx.fr>
Cc: "emacs-orgmode@gnu.org" <emacs-orgmode@gnu.org>

On Saturday, 21 Sep 2019 at 19:06, gmx wrote:
> Which formula should I use to obtain the result (hh:mm) of the sum of
> the times in the last cell of column 2? I tried this one : #+TBLFM:
> @>$2=3Dvsum(@2$2..@3$2). Result : 1:4

The underlying calculations are done using the Emacs Calc system.  In
this system, : is used to represent ratios.  If you want hours, minutes,
seconds, you need to use a different syntax.  For instance, your table
could look like this:

#+begin_src org
  |-------+----------|
  |     1 | 0@ 53'   |
  |     2 | 3@ 12'   |
  |-------+----------|
  | Total | 4@ 5' 0" |
  ,#+TBLFM: @3$2=3Dvsum(@I..@II)
#+end_src

--=20
Eric S Fraga via Emacs 27.0.50, Org release_9.2.4-401-gfabd6d