From mboxrd@z Thu Jan 1 00:00:00 1970 From: Seweryn Kokot Subject: how to extract start time and end time from the CLOCK: property Date: Mon, 18 Aug 2008 01:58:56 +0200 Message-ID: <87vdxz6vnj.fsf@poczta.po.opole.pl> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Return-path: Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1KUs1K-0007Js-8K for emacs-orgmode@gnu.org; Sun, 17 Aug 2008 19:50:50 -0400 Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1KUs1J-0007JN-EL for emacs-orgmode@gnu.org; Sun, 17 Aug 2008 19:50:49 -0400 Received: from [199.232.76.173] (port=33803 helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1KUs1J-0007J1-4K for emacs-orgmode@gnu.org; Sun, 17 Aug 2008 19:50:49 -0400 Received: from main.gmane.org ([80.91.229.2]:59675 helo=ciao.gmane.org) by monty-python.gnu.org with esmtps (TLS-1.0:RSA_AES_256_CBC_SHA1:32) (Exim 4.60) (envelope-from ) id 1KUs1J-00067t-0k for emacs-orgmode@gnu.org; Sun, 17 Aug 2008 19:50:49 -0400 Received: from list by ciao.gmane.org with local (Exim 4.43) id 1KUs1C-00017h-UV for emacs-orgmode@gnu.org; Sun, 17 Aug 2008 23:50:42 +0000 Received: from nat-warynskiego.po.opole.pl ([217.173.199.132]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Sun, 17 Aug 2008 23:50:42 +0000 Received: from s.kokot by nat-warynskiego.po.opole.pl with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Sun, 17 Aug 2008 23:50:42 +0000 List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: emacs-orgmode@gnu.org I would like to have a list of actions with starting and ending times and with duration. Now I have the column view as follows #+BEGIN: columnview :hlines 1 :id global | Action | start - end, duration | duration | |----------------+---------------------------------------------------------+----------| | * 17-08-2008 | | 3:38 | | ** DONE task1 | [2008-08-17 nie 09:03]--[2008-08-17 nie 10:04] => 1:01 | 1:01 | | ** DONE task2 | [2008-08-17 nie 10:05]--[2008-08-17 nie 10:35] => 0:30 | 0:30 | #+END: #+COLUMNS: %25ITEM(Action) %55CLOCK(start - end, duration) %8CLOCKSUM(duration) but I would like something like this #+BEGIN: columnview :hlines 1 :id global | Action | start | end | duration | |----------------+--------+--------+----------| | * 17-08-2008 | | | 3:38 | | ** DONE task1 | 09:03 | 10:04 | 1:01 | | ** DONE task2 | 10:05 | 10:35 | 0:30 | #+END: #+COLUMNS: %25ITEM(Action) %8CLOCK[start] %8CLOCK[end] %8CLOCKSUM(duration) In other words it would be nice to extract starting time and ending time from the time range in the CLOCK property so that it would be possible to insert them in two separate columns in a column view and in a dynamic block. Any ideas? regards, Seweryn Kokot