[Top][All Lists]

[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

reply via email to

[Prev in Thread] Current Thread [Next in Thread]