[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: Using Calc unit conversion functions in an Org Spreadsheet
|
From: |
Eric S Fraga |
|
Subject: |
Re: Using Calc unit conversion functions in an Org Spreadsheet |
|
Date: |
Wed, 15 Nov 2023 16:07:47 +0000 |
|
User-agent: |
gnus (Emacs 30.0.50) |
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