From mboxrd@z Thu Jan 1 00:00:00 1970 From: =?ISO-8859-1?Q?Gustav_Wikstr=F6m?= Subject: Durations and time values combined with the clock table.. Date: Sat, 9 Jul 2011 12:10:18 +0200 Message-ID: Mime-Version: 1.0 Content-Type: multipart/alternative; boundary=20cf307f3ab443729604a7a028ae Return-path: Received: from eggs.gnu.org ([140.186.70.92]:34713) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1QfUUP-0001ox-Mm for emacs-orgmode@gnu.org; Sat, 09 Jul 2011 06:10:22 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1QfUUO-0004A2-Q2 for emacs-orgmode@gnu.org; Sat, 09 Jul 2011 06:10:21 -0400 Received: from mail-iw0-f169.google.com ([209.85.214.169]:62399) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1QfUUO-00049x-L2 for emacs-orgmode@gnu.org; Sat, 09 Jul 2011 06:10:20 -0400 Received: by iwn8 with SMTP id 8so2846689iwn.0 for ; Sat, 09 Jul 2011 03:10:19 -0700 (PDT) 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 --20cf307f3ab443729604a7a028ae Content-Type: text/plain; charset=ISO-8859-7 Content-Transfer-Encoding: quoted-printable 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 hav= e 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 fro= m 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 =C4 | Task =C4 | 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=3D$3+$5;T::@2$4=3D'(apply '+ '(@3..@8));T::@2$5=3Dvsum(@3..@8);= T::@2 $6=3Dvsum(@3..@8);T Also, summations over multiple columns or rows does not seem to be working =3D/ Regards Gustav --20cf307f3ab443729604a7a028ae Content-Type: text/html; charset=ISO-8859-7 Content-Transfer-Encoding: quoted-printable Hello!

Great work with the new functions allowing time c= alculations 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 calculati= ons is the same as the time-format for the clock table? There the default i= s 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 t= o manually add :SS to each string, would be great..

And another question, negative time? I realize that this sounds strang= e from a=A0philosophical=A0point of view... but being able to use minus in = time-cells would be neat.

As an example i've a= ttached 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 =A0 =A0 | =A0 =A0 Time | =A0 =A0 =A0 =A0| Pr= oj =C4 | Task =C4 | =A0 =A0Proj |
|--------------+----------+--------+--------+--------+---------|
=
| *Total time* | *359:50* | =A0 =A0 =A0 =A0| =A0 =A0 10 | =A0 -285 | = =A0 =A02:13 |
|--------------+----------+--------+--------+------= --+---------|
| Project 1 =A0 =A0| =A0 287:55 | =A0 =A0 =A0 =A0| =A005:00 | =A0 =A0 = =A0 =A0| =A0 =A0 =A0 0 |
| Task 1 =A0 =A0 =A0 | =A0 =A0 =A0 =A0 = =A0| 239:50 | =A0 =A0 =A0 =A0| =A010:00 | 4:09:50 |
| Task 2 =A0 = =A0 =A0 | =A0 =A0 =A0 =A0 =A0| =A048:05 | =A0 =A0 =A0 =A0| =A0 -300 | =A0 4= 3:05 |
| Project 2 =A0 =A0| =A0 =A071:55 | =A0 =A0 =A0 =A0| =A005:00 | =A0 = =A0 =A0 =A0| =A0 =A0 =A0 0 |
| Task 1 =A0 =A0 =A0 | =A0 =A0 =A0 = =A0 =A0| =A047:50 | =A0 =A0 =A0 =A0| =A010:00 | =A0 57:50 |
| Tas= k 2 =A0 =A0 =A0 | =A0 =A0 =A0 =A0 =A0| =A024:05 | =A0 =A0 =A0 =A0| =A0-5:00= | =A0 29:05 |
#+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

=
Also, summations over multiple columns or rows does not seem to be w= orking =3D/

Regards Gustav
--20cf307f3ab443729604a7a028ae--