From mboxrd@z Thu Jan  1 00:00:00 1970
From: Christian Moe <mail@christianmoe.com>
Subject: Re: Error using Calc time format in table
Date: Sat, 21 Aug 2010 16:04:23 +0200
Message-ID: <4C6FDCE7.3010203@christianmoe.com>
References: <4C6FD575.4020300@christianmoe.com>
Reply-To: mail@christianmoe.com
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from [140.186.70.92] (port=47284 helo=eggs.gnu.org)
	by lists.gnu.org with esmtp (Exim 4.43) id 1OmofV-0006lP-F4
	for emacs-orgmode@gnu.org; Sat, 21 Aug 2010 10:03:34 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.69)
	(envelope-from <mail@christianmoe.com>) id 1OmofU-0006WJ-5O
	for emacs-orgmode@gnu.org; Sat, 21 Aug 2010 10:03:33 -0400
Received: from mars.hitrost.net ([91.185.193.39]:36510)
	by eggs.gnu.org with esmtp (Exim 4.69)
	(envelope-from <mail@christianmoe.com>) id 1OmofT-0006W0-VK
	for emacs-orgmode@gnu.org; Sat, 21 Aug 2010 10:03:32 -0400
Received: from lk.92.63.17.213.dc.cable.static.lj-kabel.net ([92.63.17.213]
	helo=Celebrian.local)
	by mars.hitrost.net with esmtpsa (TLSv1:AES256-SHA:256) (Exim 4.71)
	(envelope-from <mail@christianmoe.com>) id 1OmofR-0008Jn-OE
	for emacs-orgmode@gnu.org; Sat, 21 Aug 2010 16:03:29 +0200
In-Reply-To: <4C6FD575.4020300@christianmoe.com>
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <http://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <http://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=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: Org Mode <emacs-orgmode@gnu.org>

PS: It works with vsum:

| 1@ 23' 45" |
| 1@ 14' 45" |
|------------|
| 2@ 38' 30" |
#+TBLFM: @3$1=vsum(@1$1..@2$1)

But not with simple addition, subtraction etc.

I now see this was already stated at:
http://www.hollenback.net/index.php?pagename=EmacsOrgTimestamps

Unlike him, though, I'm not hung in an infinite loop, I just get 
#ERROR messages.

Yours,
CM



Christian Moe wrote:
> Hi,
> 
> When I use Calc time format in the spreadsheet, it fails to deal with 
> hours. (Using 7.01trans, pulled today.)
> 
> E.g. this simple sum gives an error:
> 
> | 1@ 23' 45" |
> | 1@ 14' 45" |
> |------------|
> | #ERROR     |
> #+TBLFM: @3$1=@1$1+@2$1
> 
> But summing just the minutes and seconds works:
> 
> | 23' 45"    |
> | 14' 45"    |
> |------------|
> | 0@ 38' 30" |
> #+TBLFM: @3$1=@1$1+@2$1
> 
> I see there's been an issue with the `@' syntax, but it seems to have 
> been solved:
> http://article.gmane.org/gmane.emacs.orgmode/8520
> 
> Am I doing something wrong?
> 
> Yours,
> Christian
> 
> _______________________________________________
> 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
> 


-- 

Christian Moe
E-mail:  mail@christianmoe.com
Website: http://christianmoe.com