From mboxrd@z Thu Jan 1 00:00:00 1970 From: Matt Price Subject: duration without hours? Date: Thu, 15 Sep 2016 22:43:44 -0400 Message-ID: Mime-Version: 1.0 Content-Type: multipart/alternative; boundary=94eb2c0ef6945b2538053c96ee01 Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:33193) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1bkj82-0000g9-CZ for emacs-orgmode@gnu.org; Thu, 15 Sep 2016 22:43:52 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1bkj7z-0008TJ-HF for emacs-orgmode@gnu.org; Thu, 15 Sep 2016 22:43:49 -0400 Received: from mail-it0-x234.google.com ([2607:f8b0:4001:c0b::234]:35786) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1bkj7z-0008Rf-CW for emacs-orgmode@gnu.org; Thu, 15 Sep 2016 22:43:47 -0400 Received: by mail-it0-x234.google.com with SMTP id r192so6949820ita.0 for ; Thu, 15 Sep 2016 19:43:46 -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" To: Org Mode --94eb2c0ef6945b2538053c96ee01 Content-Type: text/plain; charset=UTF-8 I have a silly table I am planning to use to teach myself a little bit about R; it contains durations measured in minutes and seconds: * Kayaking Log | 500m Trial | <2016-09-14 Wed> | <2016-09-15 Thu> | Mean | |------------+------------------+------------------+----------| | 1 | 00:02:48 | 00:02:34 | 00:02:48 | | 2 | 00:02:38 | 00:02:47 | | | 3 | 00:02:42 | 00:02:42 | | | 4 | 00:02:36 | 00:02:40 | | | 5 | 00:02:58 | 00:02:37 | | |------------+------------------+------------------+----------| | MEAN | 00:02:44 | 00:02:40 | | #+TBLFM: $2=vmean(@2..@-1);T::$3=vmean(@2..@-1);T::$4=vmean($2..$-1);T I have a bunch of questions but will start with what is maybe the most basic: can I write durations in minutes and seconds only? the extra 00: is sort of annoying to type when I am tired. Later I'll want to think about the best way to turn this data into a plot of fastest, slowest, and mean times day-to-day. But not tonight, I'm beat! Thanks, Matt --94eb2c0ef6945b2538053c96ee01 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: base64 PGRpdiBkaXI9Imx0ciI+PGRpdj48ZGl2PjxkaXY+PGRpdj5JIGhhdmUgYSBzaWxseSB0YWJsZSBJ IGFtIHBsYW5uaW5nIHRvIHVzZSB0byB0ZWFjaCBteXNlbGYgYSBsaXR0bGUgYml0IGFib3V0IFI7 IGl0IGNvbnRhaW5zIGR1cmF0aW9ucyBtZWFzdXJlZCBpbiBtaW51dGVzIGFuZCBzZWNvbmRzOjxi cj48YnI+PHNwYW4gc3R5bGU9ImZvbnQtZmFtaWx5Om1vbm9zcGFjZSxtb25vc3BhY2UiPiogS2F5 YWtpbmcgTG9nPGJyPnwgNTAwbSBUcmlhbCB8ICZsdDsyMDE2LTA5LTE0IFdlZCZndDsgfCAmbHQ7 MjAxNi0wOS0xNSBUaHUmZ3Q7IHzCoMKgwqDCoCBNZWFuIHw8YnI+fC0tLS0tLS0tLS0tLSstLS0t LS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS18PGJyPnzCoMKgwqDC oMKgwqDCoMKgwqAgMSB8wqDCoMKgwqDCoMKgwqDCoCAwMDowMjo0OCB8wqDCoMKgwqDCoMKgwqDC oCAwMDowMjozNCB8IDAwOjAyOjQ4IHw8YnI+fMKgwqDCoMKgwqDCoMKgwqDCoCAyIHzCoMKgwqDC oMKgwqDCoMKgIDAwOjAyOjM4IHzCoMKgwqDCoMKgwqDCoMKgIDAwOjAyOjQ3IHzCoMKgwqDCoMKg wqDCoMKgwqAgfDxicj58wqDCoMKgwqDCoMKgwqDCoMKgIDMgfMKgwqDCoMKgwqDCoMKgwqAgMDA6 MDI6NDIgfMKgwqDCoMKgwqDCoMKgwqAgMDA6MDI6NDIgfMKgwqDCoMKgwqDCoMKgwqDCoCB8PGJy PnzCoMKgwqDCoMKgwqDCoMKgwqAgNCB8wqDCoMKgwqDCoMKgwqDCoCAwMDowMjozNiB8wqDCoMKg wqDCoMKgwqDCoCAwMDowMjo0MCB8wqDCoMKgwqDCoMKgwqDCoMKgIHw8YnI+fMKgwqDCoMKgwqDC oMKgwqDCoCA1IHzCoMKgwqDCoMKgwqDCoMKgIDAwOjAyOjU4IHzCoMKgwqDCoMKgwqDCoMKgIDAw OjAyOjM3IHzCoMKgwqDCoMKgwqDCoMKgwqAgfDxicj58LS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0t LS0tLS0tLSstLS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLXw8YnI+fMKgwqDCoMKgwqDCoCBN RUFOIHzCoMKgwqDCoMKgwqDCoMKgIDAwOjAyOjQ0IHzCoMKgwqDCoMKgwqDCoMKgIDAwOjAyOjQw IHzCoMKgwqDCoMKgwqDCoMKgwqAgfDxicj48YnI+IytUQkxGTTogJDI9dm1lYW4oQDIuLkAtMSk7 VDo6JDM9dm1lYW4oQDIuLkAtMSk7VDo6JDQ9dm1lYW4oJDIuLiQtMSk7VDxicj48L3NwYW4+PGJy PjwvZGl2PkkgaGF2ZSBhIGJ1bmNoIG9mIHF1ZXN0aW9ucyBidXQgd2lsbCBzdGFydCB3aXRoIHdo YXQgaXMgbWF5YmUgdGhlIG1vc3QgYmFzaWM6IGNhbiBJIHdyaXRlIGR1cmF0aW9ucyBpbiBtaW51 dGVzIGFuZCBzZWNvbmRzIG9ubHk/IHRoZSBleHRyYSAwMDogaXMgc29ydCBvZiBhbm5veWluZyB0 byB0eXBlIHdoZW4gSSBhbSB0aXJlZC7CoCA8YnI+PGJyPjwvZGl2PkxhdGVyIEkmIzM5O2xsIHdh bnQgdG8gdGhpbmsgYWJvdXQgdGhlIGJlc3Qgd2F5IHRvIHR1cm4gdGhpcyBkYXRhIGludG8gYSBw bG90IG9mIGZhc3Rlc3QsIHNsb3dlc3QsIGFuZCBtZWFuIHRpbWVzIGRheS10by1kYXkuIEJ1dCBu b3QgdG9uaWdodCwgSSYjMzk7bSBiZWF0ITxicj48L2Rpdj5UaGFua3MsPGJyPjwvZGl2Pk1hdHQ8 YnI+PGJyPjxkaXY+PGRpdj48ZGl2PjxkaXY+PGJyPjwvZGl2PjwvZGl2PjwvZGl2PjwvZGl2Pjwv ZGl2Pg0K --94eb2c0ef6945b2538053c96ee01--