emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
* 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 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).