From: Daniel Bausch <DanielBausch@gmx.de>
To: emacs-orgmode@gnu.org
Subject: Re: Durations and time values combined with the clock table..
Date: Wed, 13 Jul 2011 08:29:08 +0200 [thread overview]
Message-ID: <201107130829.08451.DanielBausch@gmx.de> (raw)
In-Reply-To: <CA+SyOP9iOr_Hw=pUcNiHVdg_jcBEMKOjZtU4Uz5QyxQssaVwgw@mail.gmail.com>
Hello everyone,
I would like to bump this question as I am interested in a similar way.
I like to do independent (from normal time tracking) work time calculations to
get an overview of my overtime. Of course, overtime can be negative.
Hierarchically summing up days and weeks is also a wish. I think HH:MM is a
better default interpretation, too, as it would be consistent with the rest of
org-mode. What would be nice is a keystroke than inserts the current time.
What about time calculations including dates? (Should be optional and only be
a result, if non-dated time value is combined with a dated.)
* non-dated + non-dated = non-dated // normal time calculation
* non-dated - non-dated = non-dated // normal time calculation
* dated + non-dated = dated // interval addition
* dated - non-dated = dated // interval substraction
* non-dated + dated = dated // interval addition (operands switched)
* - non-dated + dated = dated // interval substract (operands switched)
* dated - dated = non-dated // get the time difference
* non-dated - dated = non-sense // time difference not calculable
* dated + dated = non-sense // maybe throw an #ERROR
* scalar * non-dated = non-dated // interval multiplication
* non-dated * scalar = non-dated // interval multiplication
* scalar / non-dated = scalar // datatype "per hour"
* non-dated / scalar = non-dated // time share
So there has to be two different data types, I think. Current time insert
would default to non-dated with C-u, it could insert a dated time value.
There could be some operator that converts from scalar to non-dated and back
(1:30 -> 1.5 ("h")).
Of course, only ideas, and sadly I currently have no time to look into it
myself ( because of the overtime ;-) ).
Best regards,
Daniel Bausch
Am Samstag 09 Juli 2011, 12:10:18 schrieb Gustav Wikström:
> Hello!
>
> Great work with the new functions allowing time calculations in the
> spreadsheet! Just a few remarks.. The default format is MM:SS and hours
> have to be qualified by using three positions HH:MM:SS.
>
> Would it not be smart if the default for this calculations is the same as
> the time-format for the clock table? There the default is HH:MM - i presume
> due to the superfluity of seconds.
>
> I do not really care which format is the default but being able to use the
> time calculation on my org-mode-generated time-table, without having to
> manually add :SS to each string, would be great..
>
> And another question, negative time? I realize that this sounds strange
> from a philosophical point of view... but being able to use minus in
> time-cells would be neat.
>
> As an example i've attached a dummy-timetable to this mail to illustrate my
> point. Column 6 and Row 2, column 5 & 6 is generated by the time-function.
>
> Clock summary at [2011-07-09 Sat 11:50]
>
> | Headline | Time | | Proj Δ | Task Δ | Proj |
> |
> |--------------+----------+--------+--------+--------+---------|
> |
> | *Total time* | *359:50* | | 10 | -285 | 2:13 |
> |
> |--------------+----------+--------+--------+--------+---------|
> |
> | Project 1 | 287:55 | | 05:00 | | 0 |
> | Task 1 | | 239:50 | | 10:00 | 4:09:50 |
> | Task 2 | | 48:05 | | -300 | 43:05 |
> | Project 2 | 71:55 | | 05:00 | | 0 |
> | Task 1 | | 47:50 | | 10:00 | 57:50 |
> | Task 2 | | 24:05 | | -5:00 | 29:05 |
>
> #+TBLFM: $6=$3+$5;T::@2$4='(apply '+ '(@3..@8));T::@2$5=vsum(@3..@8);T::@2
> $6=vsum(@3..@8);T
>
> Also, summations over multiple columns or rows does not seem to be working
> =/
>
> Regards Gustav
next prev parent reply other threads:[~2011-07-13 6:29 UTC|newest]
Thread overview: 4+ messages / expand[flat|nested] mbox.gz Atom feed top
2011-07-09 10:10 Durations and time values combined with the clock table Gustav Wikström
2011-07-13 6:29 ` Daniel Bausch [this message]
2011-07-24 16:45 ` Bastien
2011-07-24 16:44 ` Bastien
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=201107130829.08451.DanielBausch@gmx.de \
--to=danielbausch@gmx.de \
--cc=emacs-orgmode@gnu.org \
/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).