From mboxrd@z Thu Jan  1 00:00:00 1970
From: Juan <Pechiar@computer.org>
Subject: Re: Some problems with times in a spreadsheet
Date: Wed, 21 Jul 2010 10:46:17 -0300
Message-ID: <20100721134617.GK5569@soloJazz.com>
References: <87mxtljf95.fsf@linux-lqcw.site>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from [140.186.70.92] (port=38496 helo=eggs.gnu.org)
	by lists.gnu.org with esmtp (Exim 4.43) id 1ObZcw-0007mB-Kq
	for emacs-orgmode@gnu.org; Wed, 21 Jul 2010 09:46:28 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.69)
	(envelope-from <Pechiar@computer.org>) id 1ObZct-0000tL-TH
	for emacs-orgmode@gnu.org; Wed, 21 Jul 2010 09:46:25 -0400
Received: from cpoproxy1-pub.bluehost.com ([69.89.21.11]:56862)
	by eggs.gnu.org with smtp (Exim 4.69)
	(envelope-from <Pechiar@computer.org>) id 1ObZct-0000sj-Iv
	for emacs-orgmode@gnu.org; Wed, 21 Jul 2010 09:46:23 -0400
Content-Disposition: inline
In-Reply-To: <87mxtljf95.fsf@linux-lqcw.site>
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: Cecil Westerhof <cldwesterhof@gmail.com>
Cc: emacs-orgmode@gnu.org

On Wed, Jul 21, 2010 at 12:33:42PM +0200, Cecil Westerhof wrote:
> | # | Total hours | 16@ 15' 0" | 18@ 5' 0"  |
> | ^ |             | totalTime1 | totalTime2 |
> |---+-------------+------------+------------|
> #+TBLFM: $totalTime1=vsum(@-II..@-I); f2 :: $totalTime2=vsum(@-II..@-I); f2

> First of all I would like to see 16.25 instead of 16@ 15' 0". Is this
> possible?

Calc's "deg" function does this.

use deg(vsum(...)) in the formulas

Regards,
.j.