* Using Times in org-mode calc?
@ 2010-04-20 16:03 David Frascone
2010-04-21 4:12 ` Xiao-Yong Jin
0 siblings, 1 reply; 2+ messages in thread
From: David Frascone @ 2010-04-20 16:03 UTC (permalink / raw)
To: emacs-orgmode
[-- Attachment #1.1: Type: text/plain, Size: 847 bytes --]
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?
[-- Attachment #1.2: Type: text/html, Size: 1636 bytes --]
[-- Attachment #2: Type: text/plain, Size: 201 bytes --]
_______________________________________________
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
^ permalink raw reply [flat|nested] 2+ messages in thread
* Re: Using Times in org-mode calc?
2010-04-20 16:03 Using Times in org-mode calc? David Frascone
@ 2010-04-21 4:12 ` Xiao-Yong Jin
0 siblings, 0 replies; 2+ messages in thread
From: Xiao-Yong Jin @ 2010-04-21 4:12 UTC (permalink / raw)
To: David Frascone; +Cc: emacs-orgmode
On Tue, 20 Apr 2010 12:03:29 -0400, David Frascone wrote:
> 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?
Calc uses `:' as a "fraction bar" to represent fractional
numbers. So as a result,
12 6
---- = ----
34 17
I'm not sure what is the correct way to do it. But I use a
cheap hack -- abuse the degree notation. Calc understands
arc degrees as a form of 12@34'00, that is
DEGREE @ MIN ' SEC
I use DEGREE field as hours, thus normal arithmetic works
out of the box.
Hope it helps.
--
J c/* __o/*
X <\ * (__
Y */\ <
^ permalink raw reply [flat|nested] 2+ messages in thread
end of thread, other threads:[~2010-04-21 4:13 UTC | newest]
Thread overview: 2+ messages (download: mbox.gz follow: Atom feed
-- links below jump to the message on this page --
2010-04-20 16:03 Using Times in org-mode calc? David Frascone
2010-04-21 4:12 ` Xiao-Yong Jin
Code repositories for project(s) associated with this external index
https://git.savannah.gnu.org/cgit/emacs.git
https://git.savannah.gnu.org/cgit/emacs/org-mode.git
This is an external index of several public inboxes,
see mirroring instructions on how to clone and mirror
all data and code used by this external index.