emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed

• * Adding times in a table
         [not found] <mailman.41.1569081606.23821.emacs-orgmode@gnu.org>
  @ 2019-09-21 17:06 ` gmx
    2019-09-22 16:46   ` Fraga, Eric
    0 siblings, 1 reply; 2+ messages in thread
  From: gmx @ 2019-09-21 17:06 UTC (permalink / raw)
    To: emacs-orgmode
  
  [-- 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 --]
  
  ^ permalink raw reply	[flat|nested] 2+ messages in thread

• • * Re: Adding times in a table
      2019-09-21 17:06 ` Adding times in a table gmx
    @ 2019-09-22 16:46   ` Fraga, Eric
      0 siblings, 0 replies; 2+ messages in thread
    From: Fraga, Eric @ 2019-09-22 16:46 UTC (permalink / raw)
      To: gmx; +Cc: 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=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
    
    ^ permalink raw reply	[flat|nested] 2+ messages in thread

end of thread, other threads:[~2019-09-22 16:46 UTC | newest]

Thread overview: 2+ messages (download: mbox.gz follow: Atom feed
-- links below jump to the message on this page --
     [not found] <mailman.41.1569081606.23821.emacs-orgmode@gnu.org>
2019-09-21 17:06 ` Adding times in a table gmx
2019-09-22 16:46   ` Fraga, Eric

Code repositories for project(s) associated with this public inbox

	https://git.savannah.gnu.org/cgit/emacs/org-mode.git

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).