From mboxrd@z Thu Jan 1 00:00:00 1970 From: gmx Subject: Adding times in a table Date: Sat, 21 Sep 2019 19:06:44 +0200 Message-ID: <4b015484-3492-14af-9d0b-0dd56dc27f4d@gmx.fr> References: Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="------------6C4FD33C6E1D34BECE4D2DC9" Return-path: Received: from eggs.gnu.org ([2001:470:142:3::10]:50328) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1iBiqV-00064c-03 for emacs-orgmode@gnu.org; Sat, 21 Sep 2019 13:06:56 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1iBiqT-00016h-QM for emacs-orgmode@gnu.org; Sat, 21 Sep 2019 13:06:54 -0400 Received: from mout.gmx.net ([212.227.17.20]:36513) by eggs.gnu.org with esmtps (TLS1.0:DHE_RSA_AES_128_CBC_SHA1:16) (Exim 4.71) (envelope-from ) id 1iBiqT-00012o-DB for emacs-orgmode@gnu.org; Sat, 21 Sep 2019 13:06:53 -0400 Received: from [192.168.0.43] ([78.211.104.2]) by mail.gmx.com (mrgmx105 [212.227.17.174]) with ESMTPSA (Nemesis) id 1MXp9Y-1ihZ4E3B9w-00YCBf for ; Sat, 21 Sep 2019 19:06:46 +0200 In-Reply-To: Content-Language: fr 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: emacs-orgmode@gnu.org This is a multi-part message in MIME format. --------------6C4FD33C6E1D34BECE4D2DC9 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: quoted-printable Hi, I've a table like this one : Time for each task 1 00:53 2 03:12 Total 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 Each of these times are calculated by org-mode for a given task. I don't know if it's possible that they could be imported directly into the table: you'll tell me about it. Thank you much Fred (real newbie with org-mode), --------------6C4FD33C6E1D34BECE4D2DC9 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable

Hi,

I've a table like this one :



Time for each task
1
 00:53
2
 03:12
Total

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 :=C2= =A0 #+TBLFM: @>$2=3Dvsum(@2$2..@3$2). Result : 1:4

Each of these times are calculated by org-mode for a given task. I don't know if it's possible that they could be imported directly into the table: you'll tell me about it.

Thank you much

Fred (real newbie with org-mode),


--------------6C4FD33C6E1D34BECE4D2DC9--