From mboxrd@z Thu Jan 1 00:00:00 1970 From: "Giorgos Keramidas" Subject: Listing clock time in 'timeline' order Date: Mon, 08 Apr 2013 09:25:16 +0200 Message-ID: <871ualmqlf.fsf@kobe.laptop> Mime-Version: 1.0 Content-Type: text/plain Return-path: Received: from eggs.gnu.org ([208.118.235.92]:40029) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1UP6SC-00013k-VS for emacs-orgmode@gnu.org; Mon, 08 Apr 2013 03:25:31 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1UP6S8-0006tN-PT for emacs-orgmode@gnu.org; Mon, 08 Apr 2013 03:25:24 -0400 Received: from mail-ea0-x235.google.com ([2a00:1450:4013:c01::235]:59648) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1UP6S8-0006t6-I2 for emacs-orgmode@gnu.org; Mon, 08 Apr 2013 03:25:20 -0400 Received: by mail-ea0-f181.google.com with SMTP id z10so2068959ead.12 for ; Mon, 08 Apr 2013 00:25:19 -0700 (PDT) List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: emacs-orgmode@gnu.org Hi everyone, I've just started experimenting with clock-in / clock-out for multiple tasks in an org-mode buffer, and this looks awesome for tracking where time is spent, how much time was spent on each task, etc. Being able to report with 'clocktable' the cummulative time spent on each task is brilliant. I also used the agenda 'timeline' in the past, especially with tasks marked as TODO / NEXT. Now it occured to me that using clock-in/out would be a nice way to produce timesheet reports, e.g. something that would be able to take two tasks with multiple clock entries like this: * TODO Reading book 'Prescription for Chaos' :book:scifi:personal: CLOCK: [2013-04-07 Sun 17:10]--[2013-04-07 Sun 17:53] => 0:43 CLOCK: [2013-04-07 Sun 15:55]--[2013-04-07 Sun 16:08] => 0:13 CLOCK: [2013-04-07 Sun 13:58]--[2013-04-07 Sun 14:52] => 0:54 * Reading email :personal:email: # freebsd-hackers CLOCK: [2013-04-07 Sun 23:29]--[2013-04-07 Sun 23:30] => 0:00 # emacs-devel CLOCK: [2013-04-07 Sun 23:27]--[2013-04-07 Sun 23:28] => 0:01 # mercurial-main CLOCK: [2013-04-07 Sun 23:26]--[2013-04-07 Sun 23:27] => 0:01 # freebsd-current CLOCK: [2013-04-07 Sun 23:17]--[2013-04-07 Sun 23:26] => 0:09 # freebsd-developers -- deleting old 2010-2012 emails and catching up # with unread mail queue. CLOCK: [2013-04-07 Sun 23:02]--[2013-04-07 Sun 23:16] => 0:14 # freebsd-announce CLOCK: [2013-04-07 Sun 23:01]--[2013-04-07 Sun 23:02] => 0:01 # freebsd-developers CLOCK: [2013-04-07 Sun 14:08]--[2013-04-07 Sun 14:32] => 0:24 # freebsd-questions CLOCK: [2013-04-07 Sun 14:06]--[2013-04-07 Sun 14:08] => 0:02 # emacs-devel CLOCK: [2013-04-07 Sun 14:04]--[2013-04-07 Sun 14:06] => 0:02 and then produce something like clocktable, but with the clock entries sorted by time instead of added together for each task: #+BEGIN: clocksheet :scope file :tgs "+personal" Clock timesheet at [2013-04-07 Sun 23:30] | Start | Stop | Time | Headline | |----------------------+----------------------+------+---------------------------------------| | 2013-04-07 Sun 13:58 | 2013-04-07 Sun 14:52 | 0:54 | Reading book 'Prescription for Chaos' | | 2013-04-07 Sun 14:04 | 2013-04-07 Sun 14:06 | 0:02 | Reading email | | 2013-04-07 Sun 14:06 | 2013-04-07 Sun 14:08 | 0:02 | Reading email | | 2013-04-07 Sun 14:08 | 2013-04-07 Sun 14:32 | 0:24 | Reading email | | 2013-04-07 Sun 15:55 | 2013-04-07 Sun 16:08 | 0:13 | Reading book 'Prescription for Chaos' | | 2013-04-07 Sun 17:10 | 2013-04-07 Sun 17:53 | 0:43 | Reading book 'Prescription for Chaos' | | 2013-04-07 Sun 23:01 | 2013-04-07 Sun 23:02 | 0:01 | Reading email | | 2013-04-07 Sun 23:02 | 2013-04-07 Sun 23:16 | 0:14 | Reading email | | 2013-04-07 Sun 23:17 | 2013-04-07 Sun 23:26 | 0:09 | Reading email | | 2013-04-07 Sun 23:26 | 2013-04-07 Sun 23:27 | 0:01 | Reading email | | 2013-04-07 Sun 23:27 | 2013-04-07 Sun 23:28 | 0:01 | Reading email | | 2013-04-07 Sun 23:29 | 2013-04-07 Sun 23:30 | 0:01 | Reading email | |----------------------+----------------------+------+---------------------------------------| | Total time | | | | #+END: This would make org-mode an excellent tool e.g. for reporting time sheet information for projects, even for billing time spent on a project. Do you think such a feature is possible org-mode? Does it already exist in some form? If not, I'm definitely willing to help implementing it. - Giorgos