From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.io!.POSTED.blaine.gmane.org!not-for-mail From: Eric S Fraga Newsgroups: gmane.emacs.help Subject: Re: Using Calc unit conversion functions in an Org Spreadsheet Date: Wed, 15 Nov 2023 16:07:47 +0000 Organization: On the Interweb somewhere Message-ID: <878r6zngoc.fsf@ucl.ac.uk> References: <87msvfp9p1.fsf@polaris64.net> Mime-Version: 1.0 Content-Type: text/plain Injection-Info: ciao.gmane.io; posting-host="blaine.gmane.org:116.202.254.214"; logging-data="36987"; mail-complaints-to="usenet@ciao.gmane.io" User-Agent: gnus (Emacs 30.0.50) To: help-gnu-emacs@gnu.org Cancel-Lock: sha1:0CbqVSaEJwKbDK5OfTL2PdMvGxw= Original-X-From: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane-mx.org@gnu.org Wed Nov 15 17:08:31 2023 Return-path: Envelope-to: geh-help-gnu-emacs@m.gmane-mx.org Original-Received: from lists.gnu.org ([209.51.188.17]) by ciao.gmane.io with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1r3IRL-0009TK-C1 for geh-help-gnu-emacs@m.gmane-mx.org; Wed, 15 Nov 2023 17:08:31 +0100 Original-Received: from localhost ([::1] helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1r3IQo-0002wJ-O1; Wed, 15 Nov 2023 11:07:58 -0500 Original-Received: from eggs.gnu.org ([2001:470:142:3::10]) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1r3IQm-0002vp-OD for help-gnu-emacs@gnu.org; Wed, 15 Nov 2023 11:07:56 -0500 Original-Received: from ciao.gmane.io ([116.202.254.214]) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1r3IQk-0008Om-VM for help-gnu-emacs@gnu.org; Wed, 15 Nov 2023 11:07:56 -0500 Original-Received: from list by ciao.gmane.io with local (Exim 4.92) (envelope-from ) id 1r3IQh-0008hA-BY for help-gnu-emacs@gnu.org; Wed, 15 Nov 2023 17:07:51 +0100 X-Injected-Via-Gmane: http://gmane.org/ X-Url: http://twitter.com/ericsfraga/ Received-SPF: pass client-ip=116.202.254.214; envelope-from=geh-help-gnu-emacs@m.gmane-mx.org; helo=ciao.gmane.io X-Spam_score_int: -16 X-Spam_score: -1.7 X-Spam_bar: - X-Spam_report: (-1.7 / 5.0 requ) BAYES_00=-1.9, HEADER_FROM_DIFFERENT_DOMAINS=0.249, LOTS_OF_MONEY=0.001, SPF_HELO_NONE=0.001, SPF_PASS=-0.001, T_SCC_BODY_TEXT_LINE=-0.01 autolearn=no autolearn_force=no X-Spam_action: no action X-BeenThere: help-gnu-emacs@gnu.org X-Mailman-Version: 2.1.29 Precedence: list List-Id: Users list for the GNU Emacs text editor List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane-mx.org@gnu.org Original-Sender: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane-mx.org@gnu.org Xref: news.gmane.io gmane.emacs.help:145537 Archived-At: How about the following: --8<---------------cut here---------------start------------->8--- | Task | Time estimate | alternative | Rounded hours | CPH | Cost | |---------+---------------+-------------+---------------+-------------+---------------| | Task #1 | 1 hr + 35 min | 1.5 hr | 1.75 hr | 50 GBP / hr | 87.5 GBP | | Task #2 | 0 hr + 20 min | 0.25 hr | 20. min | 50 GBP / hr | 16.666667 GBP | #+TBLFM: $3=round($-1/(15 min))*hr/4;u::$4=usimplify(ceil($2*4)/4)::$6=usimplify($5*$4) --8<---------------cut here---------------end--------------->8--- (see new column "alternative") -- Eric S Fraga via gnus (Emacs 30.0.50 2023-09-14) on Debian 12.2