emacs-orgmode
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [O] CLOCKTABLE multiply time expended by hourly rate?


From: Daniel E . Doherty
Subject: Re: [O] CLOCKTABLE multiply time expended by hourly rate?
Date: Wed, 27 Jul 2011 15:51:12 -0500
User-agent: Wanderlust/2.15.9 (Almost Unreal) SEMI/1.14.6 (Maruoka) FLIM/1.14.9 (Gojō) APEL/10.7 Emacs/23.2 (x86_64-pc-linux-gnu) MULE/6.0 (HANACHIRUSATO)

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 <address@hidden> 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



reply via email to

[Prev in Thread] Current Thread [Next in Thread]