From mboxrd@z Thu Jan 1 00:00:00 1970 From: Daniel E. Doherty Subject: CLOCKTABLE multiply time expended by hourly rate? Date: Wed, 20 Jul 2011 16:38:08 -0500 Message-ID: <87y5zsws3j.wl%ded-law@ddoherty.net> Mime-Version: 1.0 (generated by SEMI 1.14.6 - "Maruoka") Content-Type: text/plain; charset=US-ASCII Return-path: Received: from eggs.gnu.org ([140.186.70.92]:38569) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1QjeTT-0008OG-JD for emacs-orgmode@gnu.org; Wed, 20 Jul 2011 17:38:37 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1QjeTQ-0002Ry-2Q for emacs-orgmode@gnu.org; Wed, 20 Jul 2011 17:38:34 -0400 Received: from mail-gw0-f41.google.com ([74.125.83.41]:34116) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1QjeTP-0002Rf-94 for emacs-orgmode@gnu.org; Wed, 20 Jul 2011 17:38:31 -0400 Received: by gwaa12 with SMTP id a12so764569gwa.0 for ; Wed, 20 Jul 2011 14:38:30 -0700 (PDT) List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: Org-mode List 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)