[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [O] Calc: Multiply time (hours) with a float
From: |
Karl Voit |
Subject: |
Re: [O] Calc: Multiply time (hours) with a float |
Date: |
Mon, 19 Sep 2016 13:43:08 +0200 |
User-agent: |
slrn/pre1.0.0-18 (Linux) |
Hallo Michael,
thanks for the pointer to http://orgmode.org/org.html#Formula-syntax-for-Lisp -
it was very helpful for my understanding.
* Michael Welle <address@hidden> wrote:
> Hello,
>
> Michael Welle <address@hidden> writes:
> [...]
>> #+TBLFM: @2$3='(* $2 (org-time-string-to-hours "$1"));L
> or converting $2 to a number before the calculation should work also,
> but is more to write ;).
Hm. I still got #ERROR. I reduced my issue to calculate the float (for hours)
without multiplying it with "value":
| time [h:m:s] | value | product |
|--------------+---------+---------|
| 09:15:00 | 2.54321 | #ERROR |
#+TBLFM: @2$3='(org-time-string-to-hours $1)
#+TBLFM: @2$3='(org-time-string-to-hours $1);L
#+TBLFM: @2$3='(org-time-string-to-hours "$1");N
... each of the TBLFM results in the same error.
At this stage, $2 is not my problem any more.
Do you have any further idea?
--
mail|git|SVN|photos|postings|SMS|phonecalls|RSS|CSV|XML to Org-mode:
> get Memacs from https://github.com/novoid/Memacs <
https://github.com/novoid/extract_pdf_annotations_to_orgmode + more on github
- [O] Calc: Multiply time (hours) with a float, Karl Voit, 2016/09/08
- Re: [O] Calc: Multiply time (hours) with a float, Karl Voit, 2016/09/11
- Re: [O] Calc: Multiply time (hours) with a float, Michael Welle, 2016/09/11
- Re: [O] Calc: Multiply time (hours) with a float, Karl Voit, 2016/09/18
- Re: [O] Calc: Multiply time (hours) with a float, Michael Welle, 2016/09/19
- Re: [O] Calc: Multiply time (hours) with a float, Michael Welle, 2016/09/19
- Re: [O] Calc: Multiply time (hours) with a float,
Karl Voit <=
- Re: [O] Calc: Multiply time (hours) with a float, Michael Welle, 2016/09/19
- Re: [O] Calc: Multiply time (hours) with a float, Karl Voit, 2016/09/19
- Re: [O] Calc: Multiply time (hours) with a float, Michael Welle, 2016/09/19
- Re: [O] Calc: Multiply time (hours) with a float, Nick Dokos, 2016/09/19
- Re: [O] Calc: Multiply time (hours) with a float, Michael Welle, 2016/09/19
- Re: [O] Calc: Multiply time (hours) with a float, Karl Voit, 2016/09/20
- Re: [O] Calc: Multiply time (hours) with a float, Bernhard Pröll, 2016/09/19
- Re: [O] Calc: Multiply time (hours) with a float - solved by updating Org, Karl Voit, 2016/09/20
- Re: [O] Calc: Multiply time (hours) with a float - solved by updating Org, Michael Welle, 2016/09/20