* CLOCKTABLE multiply time expended by hourly rate?
@ 2011-07-20 21:38 Daniel E. Doherty
2011-07-20 21:44 ` A. Ryan Reynolds
` (2 more replies)
0 siblings, 3 replies; 19+ messages in thread
From: Daniel E. Doherty @ 2011-07-20 21:38 UTC (permalink / raw)
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)
^ permalink raw reply [flat|nested] 19+ messages in thread* Re: CLOCKTABLE multiply time expended by hourly rate? 2011-07-20 21:38 CLOCKTABLE multiply time expended by hourly rate? Daniel E. Doherty @ 2011-07-20 21:44 ` A. Ryan Reynolds 2011-07-21 11:07 ` Giovanni Ridolfi 2011-07-24 22:58 ` Bastien 2 siblings, 0 replies; 19+ messages in thread From: A. Ryan Reynolds @ 2011-07-20 21:44 UTC (permalink / raw) To: Org-mode List On Jul 20, 2011, at 4:38 PM, Daniel E. Doherty wrote: > > 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. I also use clock tables in this way and would be very interested in such a feature. -- A. Ryan Reynolds ^ permalink raw reply [flat|nested] 19+ messages in thread
* Re: CLOCKTABLE multiply time expended by hourly rate? 2011-07-20 21:38 CLOCKTABLE multiply time expended by hourly rate? Daniel E. Doherty 2011-07-20 21:44 ` A. Ryan Reynolds @ 2011-07-21 11:07 ` Giovanni Ridolfi [not found] ` <87sjpzlt5x.wl%ded-law@ddoherty.net> 2011-07-24 22:58 ` Bastien 2 siblings, 1 reply; 19+ messages in thread From: Giovanni Ridolfi @ 2011-07-21 11:07 UTC (permalink / raw) To: Daniel E. Doherty; +Cc: A. Ryan Reynolds, Org-mode List Daniel E. Doherty <ded-law@ddoherty.net> writes: > 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. what about using a minute rate? (/ 50 60.0) 0.83 so: | Argo Status Hearing <2011-06-28 Tue 09:00> | | | 1:09 | 57.27 | | Letter of Discovery Deficiencies | | | 2:48 | 139.44 | #+TBLFM: $5=$4*0.83;Df2 cheers, Giovanni ^ permalink raw reply [flat|nested] 19+ messages in thread
[parent not found: <87sjpzlt5x.wl%ded-law@ddoherty.net>]
* Re: CLOCKTABLE multiply time expended by hourly rate? [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 15:55 ` Daniel E. Doherty 0 siblings, 2 replies; 19+ messages in thread From: Giovanni Ridolfi @ 2011-07-21 13:37 UTC (permalink / raw) To: Daniel E. Doherty; +Cc: Org-mode List Daniel E. Doherty <ded-law@ddoherty.net> writes: > That's certainly thinking outside the box, but I don't think it > works. Actually, Daniel you don't have to *think*, you've to demonstrate that it works or that it doesn't /tertium non datur/. > In your example, 1:09 represents 1/9th in calc's fraction mode, > not 1+9/60 which it would have to in order to compute with it. Not with GNU/Emacs 23.3 calc. If you bill 50 per 1 hour, you bill (/ 50 60.0 ) is 0.83 per minute. If you bill 1 hour + 9 minutes it is 69 minutes (* 0.83 69) 57.269999999999996 = 57.27 isn't it ? And the fifth column in my table (see below) does compute 57.27 or not? You may say: "Ah but this is only one example, you've been lucky!" I reply, what about the second line? (* (+ 120 48) 0.83) = 139.44 Calc is *really* smart, isn't it? cheers, Giovanni > > Regards, > > At Thu, 21 Jul 2011 13:07:28 +0200, > Giovanni Ridolfi wrote: >> >> Daniel E. Doherty <ded-law@ddoherty.net> writes: >> >> > 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. >> >> what about using a minute rate? >> >> (/ 50 60.0) 0.83 so: >> >> | Argo Status Hearing <2011-06-28 Tue 09:00> | | | 1:09 | 57.27 | >> | Letter of Discovery Deficiencies | | | 2:48 | 139.44 | >> #+TBLFM: $5=$4*0.83;Df2 >> >> ^ permalink raw reply [flat|nested] 19+ messages in thread
* Re: CLOCKTABLE multiply time expended by hourly rate? 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 1 sibling, 1 reply; 19+ messages in thread From: Jonathan Leech-Pepin @ 2011-07-21 14:16 UTC (permalink / raw) To: Giovanni Ridolfi; +Cc: Daniel E. Doherty, Org-mode List [-- Attachment #1: Type: text/plain, Size: 2109 bytes --] Or if you want to preserve your rounding until the last point in your calculations: | Test 1 | | | 1:15 | 62.50 | 76 | | Test 2 | | | 2:48 | 140.00 | 169 | #+TBLFM: $5=$4*(50/60.0);Df2::$6=$4+1 Since 50/60 is 0.8333... by rounding it prematurely you lose some of the precision in your billing. Column 6 is just there to confirm for me what org does when you add or multiply times. It counts the minutes as units and properly adjusts the hours to be 60*# of hours. So you just have to account for that when billing On Thu, Jul 21, 2011 at 09:37, Giovanni Ridolfi <giovanni.ridolfi@yahoo.it>wrote: > Daniel E. Doherty <ded-law@ddoherty.net> writes: > > > That's certainly thinking outside the box, but I don't think it > > works. > > Actually, Daniel you don't have to *think*, you've to demonstrate > that it works or that it doesn't /tertium non datur/. > > > In your example, 1:09 represents 1/9th in calc's fraction mode, > > not 1+9/60 which it would have to in order to compute with it. > Not with GNU/Emacs 23.3 calc. > > If you bill 50 per 1 hour, you bill > > (/ 50 60.0 ) is 0.83 per minute. > > If you bill 1 hour + 9 minutes it is 69 minutes > > (* 0.83 69) 57.269999999999996 = 57.27 > > isn't it ? > > And the fifth column in my table (see below) does compute 57.27 or not? > > You may say: "Ah but this is only one example, you've been lucky!" > > I reply, what about the second line? > > (* (+ 120 48) 0.83) = 139.44 > > Calc is *really* smart, isn't it? > > cheers, > Giovanni > > > > > Regards, > > > > At Thu, 21 Jul 2011 13:07:28 +0200, > > Giovanni Ridolfi wrote: > >> > >> Daniel E. Doherty <ded-law@ddoherty.net> writes: > >> > >> > 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. > >> > >> what about using a minute rate? > >> > >> (/ 50 60.0) 0.83 so: > >> > >> | Argo Status Hearing <2011-06-28 Tue 09:00> | | | 1:09 | 57.27 | > >> | Letter of Discovery Deficiencies | | | 2:48 | 139.44 | > >> #+TBLFM: $5=$4*0.83;Df2 > >> > >> > > [-- Attachment #2: Type: text/html, Size: 2946 bytes --] ^ permalink raw reply [flat|nested] 19+ messages in thread
* Re: CLOCKTABLE multiply time expended by hourly rate? 2011-07-21 14:16 ` Jonathan Leech-Pepin @ 2011-07-21 14:47 ` Giovanni Ridolfi 0 siblings, 0 replies; 19+ messages in thread From: Giovanni Ridolfi @ 2011-07-21 14:47 UTC (permalink / raw) To: Jonathan Leech-Pepin; +Cc: Daniel E. Doherty, Org-mode List Jonathan Leech-Pepin <jonathan.leechpepin@gmail.com> writes: >> >> >> >> | Argo Status Hearing <2011-06-28 Tue 09:00> | | | 1:15 | 62.25 | >> >> | Letter of Discovery Deficiencies | | | 2:48 | 139.44 | >> >> #+TBLFM: $5=$4*0.83;Df2 > Or if you want to preserve your rounding until the last point in your > calculations: > > | Test 1 | | | 1:15 | 62.50 | 76 | > | Test 2 | | | 2:48 | 140.00 | 169 | > #+TBLFM: $5=$4*(50/60.0);Df2::$6=$4+1 > > Since 50/60 is 0.8333... by rounding it prematurely you lose some of the > precision in your billing. yes, you're right. Thanks for pointing it out, Jonathan Giovanni ^ permalink raw reply [flat|nested] 19+ messages in thread
* Re: CLOCKTABLE multiply time expended by hourly rate? 2011-07-21 13:37 ` Giovanni Ridolfi 2011-07-21 14:16 ` Jonathan Leech-Pepin @ 2011-07-21 15:55 ` Daniel E. Doherty 2011-07-21 16:34 ` Jonathan Leech-Pepin 1 sibling, 1 reply; 19+ messages in thread From: Daniel E. Doherty @ 2011-07-21 15:55 UTC (permalink / raw) To: Org-mode List At Thu, 21 Jul 2011 15:37:55 +0200, Giovanni Ridolfi wrote: > > Daniel E. Doherty <ded-law@ddoherty.net> writes: > > > That's certainly thinking outside the box, but I don't think it > > works. > > Actually, Daniel you don't have to *think*, you've to demonstrate > that it works or that it doesn't /tertium non datur/. > > > In your example, 1:09 represents 1/9th in calc's fraction mode, > > not 1+9/60 which it would have to in order to compute with it. > Not with GNU/Emacs 23.3 calc. > > If you bill 50 per 1 hour, you bill > > (/ 50 60.0 ) is 0.83 per minute. Agreed. > > If you bill 1 hour + 9 minutes it is 69 minutes > > (* 0.83 69) 57.269999999999996 = 57.27 > > isn't it ? > It is. > And the fifth column in my table (see below) does compute 57.27 or not? > Not. At least when I do it. Here's what I get after recalcing your example. | Argo Status Hearing <2011-06-28 Tue 09:00> | | | 1:09 | 0.09 | | Letter of Discovery Deficiencies | | | 2:48 | 0.03 | #+TBLFM: $5=$4*0.83;Df2 Maybe I have a different mode setting or something. You seem to have the $4, or 1:09, being interpreted as 69, but I have it being interpreted as a calc fraction, i.e., 1/9 = 0.11111111. So 0.83 * 0.111111 gives me 0.9259, which rounds to 0.9. > You may say: "Ah but this is only one example, you've been lucky!" > I would. > I reply, what about the second line? > > (* (+ 120 48) 0.83) = 139.44 > > Calc is *really* smart, isn't it? Undoubtedly. Apart from Org, my favorite features of Emacs. I'm waiting for vi to duplicate that functionality. Thanks for taking the time to look at this. > > cheers, > Giovanni > > > > > Regards, > > > > At Thu, 21 Jul 2011 13:07:28 +0200, > > Giovanni Ridolfi wrote: > >> > >> Daniel E. Doherty <ded-law@ddoherty.net> writes: > >> > >> > 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. > >> > >> what about using a minute rate? > >> > >> (/ 50 60.0) 0.83 so: > >> > >> | Argo Status Hearing <2011-06-28 Tue 09:00> | | | 1:09 | 57.27 | > >> | Letter of Discovery Deficiencies | | | 2:48 | 139.44 | > >> #+TBLFM: $5=$4*0.83;Df2 > >> > >> ^ permalink raw reply [flat|nested] 19+ messages in thread
* Re: CLOCKTABLE multiply time expended by hourly rate? 2011-07-21 15:55 ` Daniel E. Doherty @ 2011-07-21 16:34 ` Jonathan Leech-Pepin 2011-07-21 19:13 ` Daniel E. Doherty 0 siblings, 1 reply; 19+ messages in thread From: Jonathan Leech-Pepin @ 2011-07-21 16:34 UTC (permalink / raw) To: Daniel E. Doherty; +Cc: Org-mode List [-- Attachment #1: Type: text/plain, Size: 5078 bytes --] Hi, Which version of Org are you using? 7.6 (archive from org) with very few org-related customizations (Emacs-Starter-Kit along with one or two small changes) behaved properly. I took your original table and updated the formulas and the values behaved as whole numbers rather than fractions | 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 | 250 | | DONE Draft Complaint for Damages | | | 5:40 | 17000 | | DONE Meet with Kevin Jones and Elizabeth Bennett re Complaint | | | 0:32 | 1600 | | DONE [#A] Motion for Appointment of Private Process Server | | | 1:24 | 4200 | | DONE [#A] File Affidavit of Service with Court | | | 0:25 | 1250 | | [2010-07-27 Tue 11:16] Phone call from Mark Sheister | | | 0:11 | 550 | | Research regarding compulsory counterclaim, res judicata | | | 1:23 | 4150 | | Work on brief in opposition to motion to dismiss. | | | 3:03 | 9150 | | Prepared for Hearing | | | 0:24 | 1200 | | Hearing on Case Status (Div 25:7th Flr) <2010-10-19 Tue 09:00> | | | 0:30 | 1500 | | Hearing on Motion to Dismiss <2010-11-30 Tue 09:00> | | | 1:15 | 3750 | | Hearing on Motion to Dismiss <2010-12-21 Tue 09:00> | | | 1:09 | 3450 | | Status Hearing <2011-01-25 Tue 09:00> | | | 1:31 | 4550 | | Status Hearing <2011-04-26 Tue 09:00> | | | 1:42 | 5100 | | Called Kevin [[bbdb:Stacy]]. Left voicemail to call re settlement offer. | | | 0:04 | 200 | | DONE Call [[bbdb:Sheister]] with counter offer. | | | 0:06 | 300 | | [#B] Draft Interrogatories for Rose, Swords | | | 4:48 | 14400 | | Argo Status Hearing <2011-06-28 Tue 09:00> | | | 1:09 | 3450 | | Letter of Discovery Deficiencies | | | 2:48 | 8400 | #+TBLFM: $5=$4*50;Df2 Not sure where the issue might be in your case, however the formula should behave correctly. Jonathan On Thu, Jul 21, 2011 at 11:55, Daniel E. Doherty <ded-law@ddoherty.net>wrote: > At Thu, 21 Jul 2011 15:37:55 +0200, > Giovanni Ridolfi wrote: > > > > Daniel E. Doherty <ded-law@ddoherty.net> writes: > > > > > That's certainly thinking outside the box, but I don't think it > > > works. > > > > Actually, Daniel you don't have to *think*, you've to demonstrate > > that it works or that it doesn't /tertium non datur/. > > > > > In your example, 1:09 represents 1/9th in calc's fraction mode, > > > not 1+9/60 which it would have to in order to compute with it. > > Not with GNU/Emacs 23.3 calc. > > > > If you bill 50 per 1 hour, you bill > > > > (/ 50 60.0 ) is 0.83 per minute. > > Agreed. > > > > > If you bill 1 hour + 9 minutes it is 69 minutes > > > > (* 0.83 69) 57.269999999999996 = 57.27 > > > > isn't it ? > > > > It is. > > > And the fifth column in my table (see below) does compute 57.27 or not? > > > > Not. At least when I do it. Here's what I get after recalcing your > example. > > | Argo Status Hearing <2011-06-28 Tue 09:00> | | | 1:09 | 0.09 | > | Letter of Discovery Deficiencies | | | 2:48 | 0.03 | > #+TBLFM: $5=$4*0.83;Df2 > > Maybe I have a different mode setting or something. You seem to have > the $4, or 1:09, being interpreted as 69, but I have it being > interpreted as a calc fraction, i.e., 1/9 = 0.11111111. So 0.83 * > 0.111111 gives me 0.9259, which rounds to 0.9. > > > You may say: "Ah but this is only one example, you've been lucky!" > > > > I would. > > > I reply, what about the second line? > > > > (* (+ 120 48) 0.83) = 139.44 > > > > Calc is *really* smart, isn't it? > > Undoubtedly. Apart from Org, my favorite features of Emacs. I'm > waiting for vi to duplicate that functionality. > > Thanks for taking the time to look at this. > > > > > cheers, > > Giovanni > > > > > > > > Regards, > > > > > > At Thu, 21 Jul 2011 13:07:28 +0200, > > > Giovanni Ridolfi wrote: > > >> > > >> Daniel E. Doherty <ded-law@ddoherty.net> writes: > > >> > > >> > 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. > > >> > > >> what about using a minute rate? > > >> > > >> (/ 50 60.0) 0.83 so: > > >> > > >> | Argo Status Hearing <2011-06-28 Tue 09:00> | | | 1:09 | 57.27 | > > >> | Letter of Discovery Deficiencies | | | 2:48 | 139.44 | > > >> #+TBLFM: $5=$4*0.83;Df2 > > >> > > >> > > [-- Attachment #2: Type: text/html, Size: 7870 bytes --] ^ permalink raw reply [flat|nested] 19+ messages in thread
* Re: CLOCKTABLE multiply time expended by hourly rate? 2011-07-21 16:34 ` Jonathan Leech-Pepin @ 2011-07-21 19:13 ` Daniel E. Doherty 0 siblings, 0 replies; 19+ messages in thread From: Daniel E. Doherty @ 2011-07-21 19:13 UTC (permalink / raw) To: Jonathan Leech-Pepin; +Cc: Org-mode List Thanks, Jonathan. That was it. I updated to 7.6 and now all is well. At Thu, 21 Jul 2011 12:34:15 -0400, Jonathan Leech-Pepin wrote: > > Hi, > > Which version of Org are you using? > > 7.6 (archive from org) with very few org-related customizations (Emacs-Starter-Kit > along with one or two small changes) behaved properly. > > I took your original table and updated the formulas and the values behaved as whole > numbers rather than fractions > > | 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 | 250 | > | DONE Draft Complaint for Damages | | > | 5:40 | 17000 | > | DONE Meet with Kevin Jones and Elizabeth Bennett re Complaint | | > | 0:32 | 1600 | > | DONE [#A] Motion for Appointment of Private Process Server | | > | 1:24 | 4200 | > | DONE [#A] File Affidavit of Service with Court | | > | 0:25 | 1250 | > | [2010-07-27 Tue 11:16] Phone call from Mark Sheister | | > | 0:11 | 550 | > | Research regarding compulsory counterclaim, res judicata | | > | 1:23 | 4150 | > | Work on brief in opposition to motion to dismiss. | | > | 3:03 | 9150 | > | Prepared for Hearing | | > | 0:24 | 1200 | > | Hearing on Case Status (Div 25:7th Flr) <2010-10-19 Tue 09:00> | | > | 0:30 | 1500 | > | Hearing on Motion to Dismiss <2010-11-30 Tue 09:00> | | > | 1:15 | 3750 | > | Hearing on Motion to Dismiss <2010-12-21 Tue 09:00> | | > | 1:09 | 3450 | > | Status Hearing <2011-01-25 Tue 09:00> | | > | 1:31 | 4550 | > | Status Hearing <2011-04-26 Tue 09:00> | | > | 1:42 | 5100 | > | Called Kevin [[bbdb:Stacy]]. Left voicemail to call re settlement offer. | > | | 0:04 | 200 | > | DONE Call [[bbdb:Sheister]] with counter offer. | > | | 0:06 | 300 | > | [#B] Draft Interrogatories for Rose, Swords | | > | 4:48 | 14400 | > | Argo Status Hearing <2011-06-28 Tue 09:00> | | > | 1:09 | 3450 | > | Letter of Discovery Deficiencies | | > | 2:48 | 8400 | > #+TBLFM: $5=$4*50;Df2 > > Not sure where the issue might be in your case, however the formula should behave > correctly. > > Jonathan > > On Thu, Jul 21, 2011 at 11:55, Daniel E. Doherty <ded-law@ddoherty.net> wrote: > > At Thu, 21 Jul 2011 15:37:55 +0200, > Giovanni Ridolfi wrote: > > > > Daniel E. Doherty <ded-law@ddoherty.net> writes: > > > > > That's certainly thinking outside the box, but I don't think it > > > works. > > > > Actually, Daniel you don't have to *think*, you've to demonstrate > > that it works or that it doesn't /tertium non datur/. > > > > > In your example, 1:09 represents 1/9th in calc's fraction mode, > > > not 1+9/60 which it would have to in order to compute with it. > > Not with GNU/Emacs 23.3 calc. > > > > If you bill 50 per 1 hour, you bill > > > > (/ 50 60.0 ) is 0.83 per minute. > > Agreed. > > > > > If you bill 1 hour + 9 minutes it is 69 minutes > > > > (* 0.83 69) 57.269999999999996 = 57.27 > > > > isn't it ? > > > > It is. > > > And the fifth column in my table (see below) does compute 57.27 or not? > > > > Not. At least when I do it. Here's what I get after recalcing your example. > > | Argo Status Hearing <2011-06-28 Tue 09:00> | | | 1:09 | 0.09 | > | Letter of Discovery Deficiencies | | | 2:48 | 0.03 | > #+TBLFM: $5=$4*0.83;Df2 > > Maybe I have a different mode setting or something. You seem to have > the $4, or 1:09, being interpreted as 69, but I have it being > interpreted as a calc fraction, i.e., 1/9 = 0.11111111. So 0.83 * > 0.111111 gives me 0.9259, which rounds to 0.9. > > > You may say: "Ah but this is only one example, you've been lucky!" > > > > I would. > > > I reply, what about the second line? > > > > (* (+ 120 48) 0.83) = 139.44 > > > > Calc is *really* smart, isn't it? > > Undoubtedly. Apart from Org, my favorite features of Emacs. I'm > waiting for vi to duplicate that functionality. > > Thanks for taking the time to look at this. > > > > > cheers, > > Giovanni > > > > > > > > Regards, > > > > > > At Thu, 21 Jul 2011 13:07:28 +0200, > > > Giovanni Ridolfi wrote: > > >> > > >> Daniel E. Doherty <ded-law@ddoherty.net> writes: > > >> > > >> > 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. > > >> > > >> what about using a minute rate? > > >> > > >> (/ 50 60.0) 0.83 so: > > >> > > >> | Argo Status Hearing <2011-06-28 Tue 09:00> | | | 1:09 | 57.27 | > > >> | Letter of Discovery Deficiencies | | | 2:48 | 139.44 | > > >> #+TBLFM: $5=$4*0.83;Df2 > > >> > > >> > > ^ permalink raw reply [flat|nested] 19+ messages in thread
* Re: CLOCKTABLE multiply time expended by hourly rate? 2011-07-20 21:38 CLOCKTABLE multiply time expended by hourly rate? Daniel E. Doherty 2011-07-20 21:44 ` A. Ryan Reynolds 2011-07-21 11:07 ` Giovanni Ridolfi @ 2011-07-24 22:58 ` Bastien 2011-07-25 14:53 ` Daniel E. Doherty 2011-07-25 16:01 ` Daniel E. Doherty 2 siblings, 2 replies; 19+ messages in thread From: Bastien @ 2011-07-24 22:58 UTC (permalink / raw) To: Daniel E. Doherty; +Cc: Org-mode List Hi Daniel, Daniel E. Doherty <ded-law@ddoherty.net> writes: > | 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: Please try #+TBLFM: $5=$4*50;T with latest git Org version on this table. It will multiply each HH:MM by 50 and output a HH:MM:SS string. HTH, -- Bastien ^ permalink raw reply [flat|nested] 19+ messages in thread
* Re: CLOCKTABLE multiply time expended by hourly rate? 2011-07-24 22:58 ` Bastien @ 2011-07-25 14:53 ` Daniel E. Doherty 2011-07-25 16:01 ` Daniel E. Doherty 1 sibling, 0 replies; 19+ messages in thread From: Daniel E. Doherty @ 2011-07-25 14:53 UTC (permalink / raw) To: Bastien; +Cc: Org-mode List Bastien, Here's what I get. This is a really nice feature! The times all look correct and correctly formatted. Thanks for all your work on org. Regards, | Headline | Time | | | | |---------------------------------------------------------------------------+---------+-------+------+-----------| | *Total time* | *28:09* | | | 00:00:00 | |---------------------------------------------------------------------------+---------+-------+------+-----------| | Lawsuit for Debt Against Rose Funding, LLC (1016-cv18431) | 28:09 | | | 00:00:00 | | Activities | | 28:09 | | 00:00:00 | | DONE Activity Log | | | 0:05 | 04:10:00 | | DONE Draft Complaint for Damages | | | 5:40 | 283:20:00 | | DONE Meet with Kevin Jones and Elizabeth Bennett re Complaint | | | 0:32 | 26:40:00 | | DONE [#A] Motion for Appointment of Private Process Server | | | 1:24 | 70:00:00 | | DONE [#A] File Affidavit of Service with Court | | | 0:25 | 20:50:00 | | [2010-07-27 Tue 11:16] Phone call from Mark Sheister | | | 0:11 | 09:10:00 | | Research regarding compulsory counterclaim, res judicata | | | 1:23 | 69:10:00 | | Work on brief in opposition to motion to dismiss. | | | 3:03 | 152:30:00 | | Prepared for Hearing | | | 0:24 | 20:00:00 | | Hearing on Case Status (Div 25:7th Flr) <2010-10-19 Tue 09:00> | | | 0:30 | 25:00:00 | | Hearing on Motion to Dismiss <2010-11-30 Tue 09:00> | | | 1:15 | 62:30:00 | | Hearing on Motion to Dismiss <2010-12-21 Tue 09:00> | | | 1:09 | 57:30:00 | | Status Hearing <2011-01-25 Tue 09:00> | | | 1:31 | 75:50:00 | | Status Hearing <2011-04-26 Tue 09:00> | | | 1:42 | 85:00:00 | | Called Kevin [[bbdb:Stacy]]. Left voicemail to call re settlement offer. | | | 0:04 | 03:20:00 | | DONE Call [[bbdb:Sheister]] with counter offer. | | | 0:06 | 05:00:00 | | [#B] Draft Interrogatories for Rose, Swords | | | 4:48 | 240:00:00 | | Argo Status Hearing <2011-06-28 Tue 09:00> | | | 1:09 | 57:30:00 | | Letter of Discovery Deficiencies | | | 2:48 | 140:00:00 | #+TBLFM: $5=$4*50;T #+END: At Mon, 25 Jul 2011 00:58:24 +0200, bzg wrote: > > Hi Daniel, > > Daniel E. Doherty <ded-law@ddoherty.net> writes: > > > | 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: > > Please try #+TBLFM: $5=$4*50;T with latest git Org version on this > table. It will multiply each HH:MM by 50 and output a HH:MM:SS > string. > > HTH, > > -- > Bastien -- ==================================================== 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) ^ permalink raw reply [flat|nested] 19+ messages in thread
* Re: CLOCKTABLE multiply time expended by hourly rate? 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 1 sibling, 1 reply; 19+ messages in thread From: Daniel E. Doherty @ 2011-07-25 16:01 UTC (permalink / raw) To: Bastien; +Cc: Org-mode List Bastien, Maybe I spoke too soon. When I try my original example with an 'f2' format after updating to the latest git, I get the following, so I cannot compute an invoice anymore. That, to me, is the most important application. Has the 'T' format specifier messed up the interpretation of column 4 as a number of minutes for calulation purposes? Regards, | 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;f2 #+END: At Mon, 25 Jul 2011 00:58:24 +0200, bzg wrote: > > Hi Daniel, > > Daniel E. Doherty <ded-law@ddoherty.net> writes: > > > | 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: > > Please try #+TBLFM: $5=$4*50;T with latest git Org version on this > table. It will multiply each HH:MM by 50 and output a HH:MM:SS > string. > > HTH, > > -- > Bastien > ^ permalink raw reply [flat|nested] 19+ messages in thread
* Re: CLOCKTABLE multiply time expended by hourly rate? 2011-07-25 16:01 ` Daniel E. Doherty @ 2011-07-25 21:02 ` Bastien 2011-07-25 21:55 ` Daniel E. Doherty 0 siblings, 1 reply; 19+ messages in thread From: Bastien @ 2011-07-25 21:02 UTC (permalink / raw) To: Daniel E.Doherty; +Cc: Org-mode List Hi Daniel, Daniel E.Doherty <ded-law@ddoherty.net> writes: > Has the 'T' format specifier messed up the interpretation of column 4 as > a number of minutes for calulation purposes? The 'T' format does this: 1. it converts HH:MM:SS strings to integers (number of seconds) 2. it applies the formulas to these integers 3. it formats the output as HH:MM:SS So I guess you cannot combine it with "f2" -- let me know if combining 'T' and 'f2' is the real problem at hand. Thanks! -- Bastien ^ permalink raw reply [flat|nested] 19+ messages in thread
* Re: CLOCKTABLE multiply time expended by hourly rate? 2011-07-25 21:02 ` Bastien @ 2011-07-25 21:55 ` Daniel E. Doherty 2011-07-26 0:41 ` Bastien [not found] ` <97136FFA-1146-4545-B519-F081CE9A53E0@gmail.com> 0 siblings, 2 replies; 19+ messages in thread From: Daniel E. Doherty @ 2011-07-25 21:55 UTC (permalink / raw) To: Bastien; +Cc: Org-mode List At Mon, 25 Jul 2011 23:02:38 +0200, bzg wrote: > > The 'T' format does this: > > 1. it converts HH:MM:SS strings to integers (number of seconds) > 2. it applies the formulas to these integers > 3. it formats the output as HH:MM:SS > > So I guess you cannot combine it with "f2" -- let me know if > combining 'T' and 'f2' is the real problem at hand. > Bastien, I did not use the T specifier at all. Here is the table again. I use only the f2 specifier and I get the same result with no specifier. It looks like you are converting to H:M:S form (actually, H:M or M:S form, I can't tell which) even without any format specifier. I think that without the T format specifier, org is taking the time durations to be fractions again. If you look at the fourth line of the body of my table below, the 5:40, when multiplied by 50 yields 25:4. This only makes sense if these numbers are treated as fractions. This was the behaviour that prompted my original question. It looked like it was fixed when I went from org-version 7.5 to 7.6, but it looks like its back again in the latest git pull. | 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;f2 Thanks, Dan. ^ permalink raw reply [flat|nested] 19+ messages in thread
* Re: CLOCKTABLE multiply time expended by hourly rate? 2011-07-25 21:55 ` Daniel E. Doherty @ 2011-07-26 0:41 ` Bastien 2011-07-26 13:34 ` Daniel E. Doherty [not found] ` <97136FFA-1146-4545-B519-F081CE9A53E0@gmail.com> 1 sibling, 1 reply; 19+ messages in thread From: Bastien @ 2011-07-26 0:41 UTC (permalink / raw) To: Daniel E.Doherty; +Cc: Org-mode List Hi Daniel, Daniel E.Doherty <ded-law@ddoherty.net> writes: > Bastien, I did not use the T specifier at all. Why? 'T' is needed for duration computation -- unless you use the specific calc format for time and date manipulation. HTH, -- Bastien ^ permalink raw reply [flat|nested] 19+ messages in thread
* Re: CLOCKTABLE multiply time expended by hourly rate? 2011-07-26 0:41 ` Bastien @ 2011-07-26 13:34 ` Daniel E. Doherty 2011-07-27 11:25 ` Bastien 0 siblings, 1 reply; 19+ messages in thread From: Daniel E. Doherty @ 2011-07-26 13:34 UTC (permalink / raw) To: Bastien; +Cc: Org-mode List Bastien, At Tue, 26 Jul 2011 02:41:51 +0200, bzg wrote: > > Hi Daniel, > > Daniel E.Doherty <ded-law@ddoherty.net> writes: > > > Bastien, I did not use the T specifier at all. > > Why? > > 'T' is needed for duration computation -- unless you use the > specific calc format for time and date manipulation. > I am trying to take a duration output by CLOCKTABLE and multiply it by dollars-per-hour (or dollars-per-second, either way) and get an answer in units of dollars. Can you suggest a way this can be done? I've tried several variations as set out im my prior posts with no luck. The manual uses the example of using T to add two durations to get a duration. A function like seconds() to convert the duration to an integer would do the trick. Perhaps I'm missing something obvious. Thanks for following this thread. Regards, Dan ^ permalink raw reply [flat|nested] 19+ messages in thread
* Re: CLOCKTABLE multiply time expended by hourly rate? 2011-07-26 13:34 ` Daniel E. Doherty @ 2011-07-27 11:25 ` Bastien 2011-07-27 20:51 ` Daniel E. Doherty 0 siblings, 1 reply; 19+ messages in thread From: Bastien @ 2011-07-27 11:25 UTC (permalink / raw) To: Daniel E.Doherty; +Cc: Org-mode List Hi Daniel, Daniel E.Doherty <ded-law@ddoherty.net> writes: > I am trying to take a duration output by CLOCKTABLE and multiply it by > dollars-per-hour (or dollars-per-second, either way) and get an answer > in units of dollars. I see, thanks for the explanation. > Can you suggest a way this can be done? Since latest git commit, you can now use ;t instead of ;T as a flag for durations computations. ;t will output results according to the new variable `org-table-duration-custom-format', which you can check. See this example: #+begin_src org | Task 1 | Task 2 | Total | |---------+----------+----------| | 2:12 | 1:47 | 03:59:00 | | 3:02:20 | -2:07:00 | 0.92 | #+TBLFM: @2$3=$1+$2;T::@3$3=$1+$2;t #+end_src .92 is a fraction of hours, because `org-table-duration-custom-format' is set to 'hours. HTH, -- Bastien ^ permalink raw reply [flat|nested] 19+ messages in thread
* Re: CLOCKTABLE multiply time expended by hourly rate? 2011-07-27 11:25 ` Bastien @ 2011-07-27 20:51 ` Daniel E. Doherty 0 siblings, 0 replies; 19+ messages in thread From: Daniel E. Doherty @ 2011-07-27 20:51 UTC (permalink / raw) To: Bastien; +Cc: Org-mode List Bastien, Just re-gitted (git pull && make clean && make) and applied your new 't' format specifier, and ... joy! Many thanks for following up on this. I will now retire my old Windows-based invoicing system in favor of org. Great work. Regards, Dan At Wed, 27 Jul 2011 13:25:46 +0200, bzg wrote: > > Hi Daniel, > > Daniel E.Doherty <ded-law@ddoherty.net> writes: > > > I am trying to take a duration output by CLOCKTABLE and multiply it by > > dollars-per-hour (or dollars-per-second, either way) and get an answer > > in units of dollars. > > I see, thanks for the explanation. > > > Can you suggest a way this can be done? > > Since latest git commit, you can now use ;t instead of ;T as a flag for > durations computations. ;t will output results according to the new > variable `org-table-duration-custom-format', which you can check. > > See this example: > > #+begin_src org > | Task 1 | Task 2 | Total | > |---------+----------+----------| > | 2:12 | 1:47 | 03:59:00 | > | 3:02:20 | -2:07:00 | 0.92 | > #+TBLFM: @2$3=$1+$2;T::@3$3=$1+$2;t > #+end_src > > .92 is a fraction of hours, because `org-table-duration-custom-format' > is set to 'hours. > > HTH, > > -- > Bastien ^ permalink raw reply [flat|nested] 19+ messages in thread
[parent not found: <97136FFA-1146-4545-B519-F081CE9A53E0@gmail.com>]
* Re: CLOCKTABLE multiply time expended by hourly rate? [not found] ` <97136FFA-1146-4545-B519-F081CE9A53E0@gmail.com> @ 2011-07-27 14:31 ` Daniel E. Doherty 0 siblings, 0 replies; 19+ messages in thread From: Daniel E. Doherty @ 2011-07-27 14:31 UTC (permalink / raw) To: A. Ryan Reynolds; +Cc: Daniel E. Doherty, Org-mode List At Tue, 26 Jul 2011 11:47:25 -0500, Ryan, Thanks for chiming in. I'm still in the dark on this. I'm hoping a guru will ride to the rescue. Org is without question the best organizational tool I've ever used, and to use it for billing would be a real boon to me, but I'm stuck on this issue at the moment. Regards, Dan A Ryan Reynolds wrote: > > I've been quietly following this thread and I think I should chime in > and say that I'm having the same problem. Maybe it's my lack of > experience with Calc, but I just can't get any formula acting on time > columns formatted as HH:MM to parse it as a number of minutes rather > than a ratio of HH/MM. > > -- > A. Ryan Reynolds > ^ permalink raw reply [flat|nested] 19+ messages in thread
end of thread, other threads:[~2011-07-27 20:51 UTC | newest]
Thread overview: 19+ messages (download: mbox.gz follow: Atom feed
-- links below jump to the message on this page --
2011-07-20 21:38 CLOCKTABLE multiply time expended by hourly rate? Daniel E. Doherty
2011-07-20 21:44 ` 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
Code repositories for project(s) associated with this public inbox https://git.savannah.gnu.org/cgit/emacs/org-mode.git This is a public inbox, see mirroring instructions for how to clone and mirror all data and code used for this inbox; as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).