From: Daniel E. Doherty <ded-law@ddoherty.net>
To: Org-mode List <emacs-orgmode@gnu.org>
Subject: CLOCKTABLE multiply time expended by hourly rate?
Date: Wed, 20 Jul 2011 16:38:08 -0500 [thread overview]
Message-ID: <87y5zsws3j.wl%ded-law@ddoherty.net> (raw)
Hi all,
I am trying to use orgmode to bill for time. My idea is to add a column
that multiplies the elapsed time column by an hourly rate.
Unfortunately, the elapsed time is interpreted (I believe) as a fraction
in calc, so, for example, a time of 0:58 becomes a zero.
Is there a way to make the elapsed time get formatted as a decimal, or a
function to convert it to a decimal, so I can multiply the time by a
decimal and get teh right answer.
Here is what I'm getting now, using 50 as a multiplier:
| Headline | Time | | | |
|---------------------------------------------------------------------------+---------+-------+------+-------|
| *Total time* | *28:09* | | | 0 |
|---------------------------------------------------------------------------+---------+-------+------+-------|
| Lawsuit for Debt Against Rose Funding, LLC (1016-cv18431) | 28:09 | | | 0 |
| Activities | | 28:09 | | 0 |
| DONE Activity Log | | | 0:05 | 0 |
| DONE Draft Complaint for Damages | | | 5:40 | 25:4 |
| DONE Meet with Kevin Jones and Elizabeth Bennett re Complaint | | | 0:32 | 0 |
| DONE [#A] Motion for Appointment of Private Process Server | | | 1:24 | 25:12 |
| DONE [#A] File Affidavit of Service with Court | | | 0:25 | 0 |
| [2010-07-27 Tue 11:16] Phone call from Mark Sheister | | | 0:11 | 0 |
| Research regarding compulsory counterclaim, res judicata | | | 1:23 | 50:23 |
| Work on brief in opposition to motion to dismiss. | | | 3:03 | 50 |
| Prepared for Hearing | | | 0:24 | 0 |
| Hearing on Case Status (Div 25:7th Flr) <2010-10-19 Tue 09:00> | | | 0:30 | 0 |
| Hearing on Motion to Dismiss <2010-11-30 Tue 09:00> | | | 1:15 | 10:3 |
| Hearing on Motion to Dismiss <2010-12-21 Tue 09:00> | | | 1:09 | 50:9 |
| Status Hearing <2011-01-25 Tue 09:00> | | | 1:31 | 50:31 |
| Status Hearing <2011-04-26 Tue 09:00> | | | 1:42 | 25:21 |
| Called Kevin [[bbdb:Stacy]]. Left voicemail to call re settlement offer. | | | 0:04 | 0 |
| DONE Call [[bbdb:Sheister]] with counter offer. | | | 0:06 | 0 |
| [#B] Draft Interrogatories for Rose, Swords | | | 4:48 | 25:6 |
| Argo Status Hearing <2011-06-28 Tue 09:00> | | | 1:09 | 50:9 |
| Letter of Discovery Deficiencies | | | 2:48 | 25:12 |
#+TBLFM: $5=$4*50;Df2
#+END:
Reagards,
--
====================================================
Daniel E. Doherty
Up the airy mountain,
Down the rushy glen,
We daren't go a-hunting,
For fear of little men.
--- William Allingham (Donegal, Ireland)
next reply other threads:[~2011-07-20 21:38 UTC|newest]
Thread overview: 19+ messages / expand[flat|nested] mbox.gz Atom feed top
2011-07-20 21:38 Daniel E. Doherty [this message]
2011-07-20 21:44 ` CLOCKTABLE multiply time expended by hourly rate? 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
[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
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=87y5zsws3j.wl%ded-law@ddoherty.net \
--to=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 external index
https://git.savannah.gnu.org/cgit/emacs.git
https://git.savannah.gnu.org/cgit/emacs/org-mode.git
This is an external index of several public inboxes,
see mirroring instructions on how to clone and mirror
all data and code used by this external index.