CLOCKTABLE multiply time expended by hourly rate?

[Daniel E. Doherty <ded-law@ddoherty.net>]

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)