Home
Reading
Searching
Subscribe
Sponsors
Statistics
Posting
Contact
Spam
Lists
Links
About
Hosting
Filtering
Features Download
Marketing
Archives
FAQ
Blog
 
Gmane
From: Nick Dokos <nicholas.dokos <at> hp.com>
Subject: Re: How to Calculate duration time in Table ?
Newsgroups: gmane.emacs.orgmode
Date: Tuesday 21st July 2009 19:45:48 UTC (over 7 years ago)
Xin Shi  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.
[email protected]
http://lists.gnu.org/mailman/listinfo/emacs-orgmode
 
CD: 2ms