emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
From: Bastien <bzg@altern.org>
To: "Daniel E.Doherty" <ded-law@ddoherty.net>
Cc: Org-mode List <emacs-orgmode@gnu.org>
Subject: Re: CLOCKTABLE multiply time expended by hourly rate?
Date: Wed, 27 Jul 2011 13:25:46 +0200	[thread overview]
Message-ID: <87tya7wzas.fsf@altern.org> (raw)
In-Reply-To: <87tya9upx3.wl%ded-law@ddoherty.net> (Daniel E. Doherty's message of "Tue, 26 Jul 2011 08:34:00 -0500")

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 14:52 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 [this message]
2011-07-27 20:51               ` Daniel E. Doherty
     [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=87tya7wzas.fsf@altern.org \
    --to=bzg@altern.org \
    --cc=ded-law@ddoherty.net \
    --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).