From mboxrd@z Thu Jan  1 00:00:00 1970
From: Daniel E. Doherty <ded-law@ddoherty.net>
Subject: Re: CLOCKTABLE multiply time expended by hourly rate?
Date: Wed, 27 Jul 2011 15:51:12 -0500
Message-ID: <87livjsb0f.wl%ded-law@ddoherty.net>
References: <87y5zsws3j.wl%ded-law@ddoherty.net> <87d3gzuvzj.fsf@gnu.org>
	<8762mqwdri.wl%ded-law@ddoherty.net> <8762mqjcpd.fsf@gnu.org>
	<87vcuquisf.wl%ded-law@ddoherty.net> <87fwltrhyo.fsf@gnu.org>
	<87tya9upx3.wl%ded-law@ddoherty.net> <87tya7wzas.fsf@altern.org>
Mime-Version: 1.0 (generated by SEMI 1.14.6 - "Maruoka")
Content-Type: text/plain; charset=US-ASCII
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([140.186.70.92]:33119)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <ddoherty03@gmail.com>) id 1QmB4p-0002Bt-6i
	for emacs-orgmode@gnu.org; Wed, 27 Jul 2011 16:51:37 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <ddoherty03@gmail.com>) id 1QmB4n-0006VT-Tm
	for emacs-orgmode@gnu.org; Wed, 27 Jul 2011 16:51:35 -0400
Received: from mail-gw0-f41.google.com ([74.125.83.41]:62434)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <ddoherty03@gmail.com>) id 1QmB4n-0006UM-RA
	for emacs-orgmode@gnu.org; Wed, 27 Jul 2011 16:51:33 -0400
Received: by gwaa12 with SMTP id a12so1623121gwa.0
	for <emacs-orgmode@gnu.org>; Wed, 27 Jul 2011 13:51:33 -0700 (PDT)
In-Reply-To: <87tya7wzas.fsf@altern.org>
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: </archive/html/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=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: Bastien <bzg@altern.org>
Cc: Org-mode List <emacs-orgmode@gnu.org>


Bastien,

Just re-gitted (git pull && make clean && make) and applied your new 't'
format specifier, and ... joy!  Many thanks for following up on this.  I
will now retire my old Windows-based invoicing system in favor of org.

Great work.

Regards,

Dan

At Wed, 27 Jul 2011 13:25:46 +0200,
bzg wrote:
> 
> Hi Daniel,
> 
> Daniel E.Doherty <ded-law@ddoherty.net> writes:
> 
> > I am trying to take a duration output by CLOCKTABLE and multiply it by
> > dollars-per-hour (or dollars-per-second, either way) and get an answer
> > in units of dollars.
> 
> I see, thanks for the explanation.
> 
> > Can you suggest a way this can be done?  
> 
> Since latest git commit, you can now use ;t instead of ;T as a flag for
> durations computations.  ;t will output results according to the new
> variable `org-table-duration-custom-format', which you can check.
> 
> See this example:
> 
> #+begin_src org
>   |  Task 1 |   Task 2 |    Total |
>   |---------+----------+----------|
>   |    2:12 |     1:47 | 03:59:00 |
>   | 3:02:20 | -2:07:00 |     0.92 |
>   #+TBLFM: @2$3=$1+$2;T::@3$3=$1+$2;t
> #+end_src
> 
> .92 is a fraction of hours, because `org-table-duration-custom-format'
> is set to 'hours.
> 
> HTH,
> 
> -- 
>  Bastien