From: Jonathan Leech-Pepin <jonathan.leechpepin@gmail.com>
To: Giovanni Ridolfi <giovanni.ridolfi@yahoo.it>
Cc: "Daniel E. Doherty" <ded-law@ddoherty.net>,
Org-mode List <emacs-orgmode@gnu.org>
Subject: Re: CLOCKTABLE multiply time expended by hourly rate?
Date: Thu, 21 Jul 2011 10:16:17 -0400 [thread overview]
Message-ID: <CAHRqSkS_LiBjV32R2xbgZOAcNDySDqA35CUvMWhQaH2HxzfwFQ@mail.gmail.com> (raw)
In-Reply-To: <83hb6fbvpo.fsf@yahoo.it>
[-- 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 --]
next prev parent reply other threads:[~2011-07-21 14:16 UTC|newest]
Thread overview: 19+ messages / expand[flat|nested] mbox.gz Atom feed top
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 [this message]
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
Avoid top-posting and favor interleaved quoting:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
List information: https://www.orgmode.org/
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=CAHRqSkS_LiBjV32R2xbgZOAcNDySDqA35CUvMWhQaH2HxzfwFQ@mail.gmail.com \
--to=jonathan.leechpepin@gmail.com \
--cc=ded-law@ddoherty.net \
--cc=emacs-orgmode@gnu.org \
--cc=giovanni.ridolfi@yahoo.it \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* If your mail client supports setting the In-Reply-To header
via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line
before the message body.
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).