[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[O] CLOCKTABLE multiply time expended by hourly rate?
From: |
Daniel E . Doherty |
Subject: |
[O] CLOCKTABLE multiply time expended by hourly rate? |
Date: |
Wed, 20 Jul 2011 16:38:08 -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) |
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)
- [O] CLOCKTABLE multiply time expended by hourly rate?,
Daniel E . Doherty <=
Re: [O] CLOCKTABLE multiply time expended by hourly rate?, Bastien, 2011/07/24