From mboxrd@z Thu Jan  1 00:00:00 1970
From: Seweryn Kokot <s.kokot@po.opole.pl>
Subject: Re: how to extract start time and end time from the CLOCK: property
Date: Wed, 03 Sep 2008 21:10:52 +0200
Message-ID: <87bpz5jb9f.fsf@poczta.po.opole.pl>
References: <87vdxz6vnj.fsf@poczta.po.opole.pl>
	<F19777DE-4A5F-497C-8055-7A1EDA999006@uva.nl>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43)
	id 1KaxcE-0001Tz-5j
	for emacs-orgmode@gnu.org; Wed, 03 Sep 2008 15:02:06 -0400
Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43)
	id 1KaxcB-0001Qc-J3
	for emacs-orgmode@gnu.org; Wed, 03 Sep 2008 15:02:05 -0400
Received: from [199.232.76.173] (port=54858 helo=monty-python.gnu.org)
	by lists.gnu.org with esmtp (Exim 4.43) id 1KaxcB-0001QN-DB
	for emacs-orgmode@gnu.org; Wed, 03 Sep 2008 15:02:03 -0400
Received: from main.gmane.org ([80.91.229.2]:43665 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 <geo-emacs-orgmode@m.gmane.org>)
	id 1KaxcB-00005b-05
	for emacs-orgmode@gnu.org; Wed, 03 Sep 2008 15:02:03 -0400
Received: from list by ciao.gmane.org with local (Exim 4.43)
	id 1Kaxc2-00037V-B7
	for emacs-orgmode@gnu.org; Wed, 03 Sep 2008 19:01:54 +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 <emacs-orgmode@gnu.org>; Wed, 03 Sep 2008 19:01:54 +0000
Received: from s.kokot by nat-warynskiego.po.opole.pl with local (Gmexim 0.1
	(Debian)) id 1AlnuQ-0007hv-00
	for <emacs-orgmode@gnu.org>; Wed, 03 Sep 2008 19:01:54 +0000
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <http://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/pipermail/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <http://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=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

Carsten Dominik <dominik@science.uva.nl> writes:

> Hi Seweryn,
>
> please see
>
> http://thread.gmane.org/gmane.emacs.orgmode/7430/focus=7430

Hi Carsten

Thanks a lot! This is exactly what I wanted. In my case the following
works

(defun my-org-column-cleaner (title value)
   (cond
     ((equal title "Start")
      (if (and value (>= (length value) 40))
          (substring value 16 21)
         nil ; there was no value, or it was a short string
         ))
	 ((equal title "End")
      (if (and value (>= (length value) 40))
          (substring value 40 45)
         nil ; there was no value, or it was a short string
         ))
      (t nil)))
(setq org-columns-modify-value-for-display-function 'my-org-column-cleaner)

and

#+COLUMNS: %50ITEM(Action) %8CLOCK(Start) %8CLOCK(End) %7CLOCKSUM(Clocked)


The only problem is that Emacs+orgmode under Linux gives

[2008-08-19 wto 07:26]--[2008-08-19 wto 08:26]

and under Windows I got

[2008-08-05 Wt 11:44]--[2008-08-05 Wt 13:47]

I guess this is caused by the system locales. Is it possible to make it
consistent with some settings in .emacs file?

regards,
-- 
Seweryn