From mboxrd@z Thu Jan 1 00:00:00 1970 From: "A. Ryan Reynolds" Subject: Re: CLOCKTABLE multiply time expended by hourly rate? Date: Wed, 20 Jul 2011 16:44:38 -0500 Message-ID: <0D7C1E21-E30F-420C-853C-F71792566D07@gmail.com> References: <87y5zsws3j.wl%ded-law@ddoherty.net> Mime-Version: 1.0 (Apple Message framework v1084) Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable Return-path: Received: from eggs.gnu.org ([140.186.70.92]:52336) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1QjeZQ-0001hy-2w for emacs-orgmode@gnu.org; Wed, 20 Jul 2011 17:44:45 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1QjeZN-0003ew-Rf for emacs-orgmode@gnu.org; Wed, 20 Jul 2011 17:44:43 -0400 Received: from mail-yw0-f41.google.com ([209.85.213.41]:55532) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1QjeZN-0003ei-CH for emacs-orgmode@gnu.org; Wed, 20 Jul 2011 17:44:41 -0400 Received: by ywm39 with SMTP id 39so359762ywm.0 for ; Wed, 20 Jul 2011 14:44:40 -0700 (PDT) In-Reply-To: <87y5zsws3j.wl%ded-law@ddoherty.net> 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 On Jul 20, 2011, at 4:38 PM, Daniel E. Doherty wrote: >=20 > Hi all, >=20 > 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. >=20 > 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. I also use clock tables in this way and would be very interested in such = a feature. -- A. Ryan Reynolds