From mboxrd@z Thu Jan 1 00:00:00 1970 From: Richard Lawrence Subject: Re: How to analyze clocking reports (e. g. with spreadsheet application)? Date: Sat, 27 Apr 2013 16:27:21 -0700 Message-ID: <87sj2bblly.fsf@berkeley.edu> References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Return-path: Received: from eggs.gnu.org ([208.118.235.92]:55808) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1UWEUB-0003GZ-59 for emacs-orgmode@gnu.org; Sat, 27 Apr 2013 19:24:56 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1UWEUA-0007p4-0c for emacs-orgmode@gnu.org; Sat, 27 Apr 2013 19:24:55 -0400 Received: from plane.gmane.org ([80.91.229.3]:44659) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1UWEU9-0007oY-NE for emacs-orgmode@gnu.org; Sat, 27 Apr 2013 19:24:53 -0400 Received: from list by plane.gmane.org with local (Exim 4.69) (envelope-from ) id 1UWEU3-0006PM-Aa for emacs-orgmode@gnu.org; Sun, 28 Apr 2013 01:24:47 +0200 Received: from c-67-164-33-170.hsd1.ca.comcast.net ([67.164.33.170]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Sun, 28 Apr 2013 01:24:47 +0200 Received: from richard.lawrence by c-67-164-33-170.hsd1.ca.comcast.net with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Sun, 28 Apr 2013 01:24:47 +0200 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 Martin, Martin writes: > I'm using the org-mode clocking features (in org-mode 7.9.4) extensively > to document how much time I spent with which task and when. > > I wonder how I can export the data (e. g. to MS Excel) for further analysis; > * time consumed by different projects > * interruptions and "jumping" from task to task > * time consumed by tasks with a special tag > etc. Have you looked at this section in the manual? I don't use many of these features myself, but I think Org itself can tell you many of these things without exporting the data to a separate tool: http://orgmode.org/org.html#The-clock-table -- Best, Richard