From mboxrd@z Thu Jan 1 00:00:00 1970 From: Daniel Bausch Subject: Re: Durations and time values combined with the clock table.. Date: Wed, 13 Jul 2011 08:29:08 +0200 Message-ID: <201107130829.08451.DanielBausch@gmx.de> References: Mime-Version: 1.0 Content-Type: Text/Plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Return-path: Received: from eggs.gnu.org ([140.186.70.92]:40634) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1Qgswc-0006nn-Og for emacs-orgmode@gnu.org; Wed, 13 Jul 2011 02:29:16 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1Qgswa-0005hu-Om for emacs-orgmode@gnu.org; Wed, 13 Jul 2011 02:29:14 -0400 Received: from mailout-de.gmx.net ([213.165.64.22]:33746) by eggs.gnu.org with smtp (Exim 4.71) (envelope-from ) id 1QgswZ-0005hC-M6 for emacs-orgmode@gnu.org; Wed, 13 Jul 2011 02:29:12 -0400 In-Reply-To: List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: emacs-orgmode@gnu.org 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=20 get an overview of my overtime. Of course, overtime can be negative.=20 Hierarchically summing up days and weeks is also a wish. I think HH:MM is = a=20 better default interpretation, too, as it would be consistent with the rest= of=20 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=20 a result, if non-dated time value is combined with a dated.) * non-dated + non-dated =3D non-dated // normal time calculation * non-dated - non-dated =3D non-dated // normal time calculation * dated + non-dated =3D dated // interval addition * dated - non-dated =3D dated // interval substraction * non-dated + dated =3D dated // interval addition (operands switche= d) * - non-dated + dated =3D dated // interval substract (operands switch= ed) * dated - dated =3D non-dated // get the time difference * non-dated - dated =3D non-sense // time difference not calculable * dated + dated =3D non-sense // maybe throw an #ERROR * scalar * non-dated =3D non-dated // interval multiplication * non-dated * scalar =3D non-dated // interval multiplication * scalar / non-dated =3D scalar // datatype "per hour" * non-dated / scalar =3D non-dated // time share So there has to be two different data types, I think. Current time insert= =20 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 bac= k=20 (1:30 -> 1.5 ("h")). Of course, only ideas, and sadly I currently have no time to look into it=20 myself ( because of the overtime ;-) ). Best regards, Daniel Bausch Am Samstag 09 Juli 2011, 12:10:18 schrieb Gustav Wikstr=C3=B6m: > Hello! >=20 > 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. >=20 > 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 presu= me > due to the superfluity of seconds. >=20 > 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.. >=20 > 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. >=20 > 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. >=20 > Clock summary at [2011-07-09 Sat 11:50] >=20 > | Headline | Time | | Proj =CE=94 | Task =CE=94 | 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 | >=20 > #+TBLFM: $6=3D$3+$5;T::@2$4=3D'(apply '+ '(@3..@8));T::@2$5=3Dvsum(@3..@8= );T::@2 > $6=3Dvsum(@3..@8);T >=20 > Also, summations over multiple columns or rows does not seem to be working > =3D/ >=20 > Regards Gustav