From mboxrd@z Thu Jan 1 00:00:00 1970 From: David Frascone Subject: Using Times in org-mode calc? Date: Tue, 20 Apr 2010 12:03:29 -0400 Message-ID: Mime-Version: 1.0 Content-Type: multipart/mixed; boundary="===============1143813501==" Return-path: Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1O4FvF-0002Pd-2O for emacs-orgmode@gnu.org; Tue, 20 Apr 2010 12:03:37 -0400 Received: from [140.186.70.92] (port=34852 helo=eggs.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1O4FvD-0002P9-Iu for emacs-orgmode@gnu.org; Tue, 20 Apr 2010 12:03:36 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.69) (envelope-from ) id 1O4FvB-00069G-T8 for emacs-orgmode@gnu.org; Tue, 20 Apr 2010 12:03:35 -0400 Received: from mail-wy0-f169.google.com ([74.125.82.169]:62813) by eggs.gnu.org with esmtp (Exim 4.69) (envelope-from ) id 1O4FvB-00068v-Nu for emacs-orgmode@gnu.org; Tue, 20 Apr 2010 12:03:33 -0400 Received: by wyg36 with SMTP id 36so126833wyg.0 for ; Tue, 20 Apr 2010 09:03:32 -0700 (PDT) List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: emacs-orgmode@gnu.org --===============1143813501== Content-Type: multipart/alternative; boundary=0016e65aee52f99fc50484ad37f3 --0016e65aee52f99fc50484ad37f3 Content-Type: text/plain; charset=ISO-8859-1 I'm trying to make a running log, but I can't seem to get times entered in HH:MM:SS to work right. Well -- they work right, but I can't get things to re-display in that format. And, sometimes math is just screwy. For example: | Distance | Time | Time | Speed | Speed | | (Miles) | HH:MM:SS | Decimal | (MPH) | (Min/Mile) | |----------+----------+---------+-------+------------| | 2.0 | 12:34 | 3:17 | | | | 3 | 30:45 | | | | #+TBLFM: $3=$2/2 As you can see the 3:17 is some very strange calculation. Not sure what it did. If I use "=$2", it returns 6:17 It seemed like it was doing something wright, but, now it looks like maybe it just doesn't understand HH:MM:SS format? What would be the easiest way to implement something like that table? Lisp functions? --0016e65aee52f99fc50484ad37f3 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
I'm trying to make a running log, but I can't seem to get times= entered in HH:MM:SS to work right.

Well -- they work right, but I c= an't get things to re-display in that format.=A0 And, sometimes math is= just screwy.

For example:

| Distance |=A0=A0=A0=A0 Time | Time=A0=A0=A0 | Speed | Speed=A0=A0= =A0=A0=A0 |
|=A0 (Miles) | HH:MM:SS= | Decimal | (MPH) | (Min/Mile) |
|-------= ---+----------+---------+-------+------------|
|=A0=A0=A0=A0=A0 2.0 |= =A0=A0=A0 12:34 | 3:17=A0=A0=A0 |=A0=A0=A0=A0=A0=A0 |=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0 |
|=A0=A0=A0=A0=A0=A0=A0 3 |= =A0=A0=A0 30:45 |=A0=A0=A0=A0=A0=A0=A0=A0 |=A0=A0=A0=A0=A0=A0 |=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0 |
=A0#+TBLFM: $3=3D$2/2


As you= can see the 3:17 is some very strange calculation.=A0 Not sure what it did= .=A0 If I use "=3D$2", it returns 6:17

It seemed like it was doing something wright, but, now it looks like ma= ybe it just doesn't understand HH:MM:SS format?

What would be th= e easiest way to implement something like that table?=A0 Lisp functions?=A0=
--0016e65aee52f99fc50484ad37f3-- --===============1143813501== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline _______________________________________________ Emacs-orgmode mailing list Please use `Reply All' to send replies to the list. Emacs-orgmode@gnu.org http://lists.gnu.org/mailman/listinfo/emacs-orgmode --===============1143813501==--