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 wr
Hi Daniel,
Daniel E.Doherty 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 lat
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 th
Bastien,
At Tue, 26 Jul 2011 02:41:51 +0200,
bzg wrote:
>
> Hi Daniel,
>
> Daniel E.Doherty 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
Hi Daniel,
Daniel E.Doherty 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
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 i
Hi Daniel,
Daniel E.Doherty 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
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
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| | | |
|--
Hi Daniel,
Daniel E. Doherty writes:
> | Headline |
> Time| | | |
> |---+-+---+--+---|
> | *Total time*
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
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
| H
At Thu, 21 Jul 2011 15:37:55 +0200,
Giovanni Ridolfi wrote:
>
> Daniel E. Doherty 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 datu
Jonathan Leech-Pepin 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
> cal
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 bi
Daniel E. Doherty 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
Daniel E. Doherty 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.2
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, fo
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
19 matches
Mail list logo
