emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
From: Daniel E. Doherty <ded-law@ddoherty.net>
To: Bastien <bzg@altern.org>
Cc: Org-mode List <emacs-orgmode@gnu.org>
Subject: Re: CLOCKTABLE multiply time expended by hourly rate?
Date: Wed, 27 Jul 2011 15:51:12 -0500	[thread overview]
Message-ID: <87livjsb0f.wl%ded-law@ddoherty.net> (raw)
In-Reply-To: <87tya7wzas.fsf@altern.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

  reply	other threads:[~2011-07-27 20:51 UTC|newest]

Thread overview: 19+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2011-07-20 21:38 CLOCKTABLE multiply time expended by hourly rate? Daniel E. Doherty
2011-07-20 21:44 ` A. Ryan Reynolds
2011-07-21 11:07 ` Giovanni Ridolfi
     [not found]   ` <87sjpzlt5x.wl%ded-law@ddoherty.net>
2011-07-21 13:37     ` Giovanni Ridolfi
2011-07-21 14:16       ` Jonathan Leech-Pepin
2011-07-21 14:47         ` Giovanni Ridolfi
2011-07-21 15:55       ` Daniel E. Doherty
2011-07-21 16:34         ` Jonathan Leech-Pepin
2011-07-21 19:13           ` Daniel E. Doherty
2011-07-24 22:58 ` Bastien
2011-07-25 14:53   ` Daniel E. Doherty
2011-07-25 16:01   ` Daniel E. Doherty
2011-07-25 21:02     ` Bastien
2011-07-25 21:55       ` Daniel E. Doherty
2011-07-26  0:41         ` Bastien
2011-07-26 13:34           ` Daniel E. Doherty
2011-07-27 11:25             ` Bastien
2011-07-27 20:51               ` Daniel E. Doherty [this message]
     [not found]         ` <97136FFA-1146-4545-B519-F081CE9A53E0@gmail.com>
2011-07-27 14:31           ` Daniel E. Doherty

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

  Avoid top-posting and favor interleaved quoting:
  https://en.wikipedia.org/wiki/Posting_style#Interleaved_style

  List information: https://www.orgmode.org/

* Reply using the --to, --cc, and --in-reply-to
  switches of git-send-email(1):

  git send-email \
    --in-reply-to=87livjsb0f.wl%ded-law@ddoherty.net \
    --to=ded-law@ddoherty.net \
    --cc=bzg@altern.org \
    --cc=emacs-orgmode@gnu.org \
    /path/to/YOUR_REPLY

  https://kernel.org/pub/software/scm/git/docs/git-send-email.html

* If your mail client supports setting the In-Reply-To header
  via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line before the message body.
Code repositories for project(s) associated with this public inbox

	https://git.savannah.gnu.org/cgit/emacs/org-mode.git

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).