[Orgmode] How to Calculate duration time in Table ?
Hello, I have a table in org which stores the date, I'm wondering if there is any function to calculate the duration? For example: | Start Date | End Date | Duration | |++--| | 2004.08.07 | 2005.07.08 | | I tried to use B-C, but failed ... Thanks! Xin ___ Emacs-orgmode mailing list Remember: use `Reply All' to send replies to the list. Emacs-orgmode@gnu.org http://lists.gnu.org/mailman/listinfo/emacs-orgmode
Re: [Orgmode] How to Calculate duration time in Table ?
Xin Shi shixin...@gmail.com wrote: I have a table in org which stores the date, I'm wondering if there is any function to calculate the duration? For example: | Start Date | End Date | Duration | |++--| | 2004.08.07 | 2005.07.08 | | I tried to use B-C, but failed ... Try the following: | Start Date | End Date | Duration | |++--| | 2004.08.07 | 2005.07.08 | 335 | #+TBLFM: $3=(date($2)-date($1)) See this thread: http://thread.gmane.org/gmane.emacs.orgmode/7741 as well as this post (which is really a followup on the above): http://article.gmane.org/gmane.emacs.orgmode/7753 The problem that this last article pointed out was solved in http://article.gmane.org/gmane.emacs.orgmode/8001 and Chris Randle's original musings are at http://article.gmane.org/gmane.emacs.orgmode/6536/ HTH, Nick ___ Emacs-orgmode mailing list Remember: use `Reply All' to send replies to the list. Emacs-orgmode@gnu.org http://lists.gnu.org/mailman/listinfo/emacs-orgmode
Re: [Orgmode] How to Calculate duration time in Table ?
Nick Dokos nicholas.do...@hp.com writes: Try the following: | Start Date | End Date | Duration | |++--| | 2004.08.07 | 2005.07.08 | 335 | #+TBLFM: $3=(date($2)-date($1)) Nice, I added a note in Worg/org-hacks.org. -- Bastien ___ Emacs-orgmode mailing list Remember: use `Reply All' to send replies to the list. Emacs-orgmode@gnu.org http://lists.gnu.org/mailman/listinfo/emacs-orgmode
Re: [Orgmode] How to Calculate duration time in Table ?
Bastien bastiengue...@googlemail.com wrote: Nick Dokos nicholas.do...@hp.com writes: Try the following: | Start Date | End Date | Duration | |++--| | 2004.08.07 | 2005.07.08 | 335 | #+TBLFM: $3=(date($2)-date($1)) Nice, I added a note in Worg/org-hacks.org. Thanks for doing that. The only problem is that the TBLFM line has been stripped, so it's not clear *what* the solution is, unless one follows the link to the message. Would it work better if I had quoted the above (e.g. boxquote or the gnus message method)? Thanks, Nick ___ Emacs-orgmode mailing list Remember: use `Reply All' to send replies to the list. Emacs-orgmode@gnu.org http://lists.gnu.org/mailman/listinfo/emacs-orgmode
Re: [Orgmode] How to Calculate duration time in Table ?
Nick Dokos nicholas.do...@hp.com writes: Bastien bastiengue...@googlemail.com wrote: Nick Dokos nicholas.do...@hp.com writes: Try the following: | Start Date | End Date | Duration | |++--| | 2004.08.07 | 2005.07.08 | 335 | #+TBLFM: $3=(date($2)-date($1)) Nice, I added a note in Worg/org-hacks.org. Thanks for doing that. The only problem is that the TBLFM line has been stripped, so it's not clear *what* the solution is, unless one follows the link to the message. Opps, fixed! Thanks for checking. Would it work better if I had quoted the above (e.g. boxquote or the gnus message method)? No no, I just need more sleep :) -- Bastien ___ Emacs-orgmode mailing list Remember: use `Reply All' to send replies to the list. Emacs-orgmode@gnu.org http://lists.gnu.org/mailman/listinfo/emacs-orgmode
Re: [Orgmode] How to Calculate duration time in Table ?
Cool! thanks for all :) Xin On Tue, Jul 21, 2009 at 7:47 PM, Bastien bastiengue...@googlemail.comwrote: Nick Dokos nicholas.do...@hp.com writes: Bastien bastiengue...@googlemail.com wrote: Nick Dokos nicholas.do...@hp.com writes: Try the following: | Start Date | End Date | Duration | |++--| | 2004.08.07 | 2005.07.08 | 335 | #+TBLFM: $3=(date($2)-date($1)) Nice, I added a note in Worg/org-hacks.org. Thanks for doing that. The only problem is that the TBLFM line has been stripped, so it's not clear *what* the solution is, unless one follows the link to the message. Opps, fixed! Thanks for checking. Would it work better if I had quoted the above (e.g. boxquote or the gnus message method)? No no, I just need more sleep :) -- Bastien ___ Emacs-orgmode mailing list Remember: use `Reply All' to send replies to the list. Emacs-orgmode@gnu.org http://lists.gnu.org/mailman/listinfo/emacs-orgmode ___ Emacs-orgmode mailing list Remember: use `Reply All' to send replies to the list. Emacs-orgmode@gnu.org http://lists.gnu.org/mailman/listinfo/emacs-orgmode