Adding times in a table

Adding times in a table

[gmx]

[-- Attachment #1: Type: text/plain, Size: 513 bytes --]

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=vsum(@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),



[-- Attachment #2: Type: text/html, Size: 1457 bytes --]

Re: Adding times in a table

[Fraga, Eric]

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=vsum(@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=vsum(@I..@II)
#+end_src

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