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