* 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
* 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?
[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
* 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
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).