Re: [O] Calc: Multiply time (hours) with a float

2016-09-20 Thread Karl Voit
* Michael Welle wrote: > Hello, > >> | time [h:m:s] | value | product | >> |--+-+-| >> | 09:15:00 | 2.54321 | #ERROR | >> >> #+TBLFM: @2$3='(org-time-string-to-hours $1) > I'm just back from a 20km hike and in the woods my mind came up with a > silly question ;)

Re: [O] Calc: Multiply time (hours) with a float - solved by updating Org

2016-09-20 Thread Michael Welle
Hello, Karl Voit writes: > * Karl Voit wrote: >> >> | time [h:m:s] | value | product | >> |--+-+-| >> | 09:15:00 | 2.54321 | #ERROR | >> #+TBLFM: @2$3='(org-time-string-to-hours $1) >> >> OK, this is my current issue then. >> >> I'm using Org from git/maint ve

Re: [O] Calc: Multiply time (hours) with a float - solved by updating Org

2016-09-20 Thread Karl Voit
* Karl Voit wrote: > > | time [h:m:s] | value | product | > |--+-+-| > | 09:15:00 | 2.54321 | #ERROR | > #+TBLFM: @2$3='(org-time-string-to-hours $1) > > OK, this is my current issue then. > > I'm using Org from git/maint version 8.3.4 > (release_8.3.4-33-gd522fc

Re: [O] Calc: Multiply time (hours) with a float

2016-09-19 Thread Michael Welle
Hello, Nick Dokos writes: > Michael Welle writes: > >> Hello, >> >> Karl Voit writes: >> >>> * Michael Welle wrote: Karl Voit writes: >> [...] >>> #+TBLFM: @2$3='(* $2 (org-time-string-to-hours "$1"));L >> or converting $2 to a number before the calculation should

Re: [O] Calc: Multiply time (hours) with a float

2016-09-19 Thread Nick Dokos
Michael Welle writes: > Hello, > > Karl Voit writes: > >> * Michael Welle wrote: >>> >>> Karl Voit 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 ;). >

Re: [O] Calc: Multiply time (hours) with a float

2016-09-19 Thread Bernhard Pröll
Hi, FWIW, there is a org-table-toggle-formula-debugger command. On Mon, Sep 19 2016, Karl Voit wrote: > * Michael Welle wrote: >> >> Karl Voit writes: >> [...] > #+TBLFM: @2$3='(* $2 (org-time-string-to-hours "$1"));L or converting $2 to a number before the calculation should wo

Re: [O] Calc: Multiply time (hours) with a float

2016-09-19 Thread Michael Welle
Hello, Karl Voit writes: > * Michael Welle wrote: >> >> Karl Voit 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 reduc

Re: [O] Calc: Multiply time (hours) with a float

2016-09-19 Thread Karl Voit
* Michael Welle wrote: > > Karl Voit 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

Re: [O] Calc: Multiply time (hours) with a float

2016-09-19 Thread Michael Welle
Hello, Karl Voit writes: > 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 wrote: >> Hello, >> >> Michael Welle writes: >> [...] >>> #+TBLFM: @2$3='(* $2 (org-time-string-to-ho

Re: [O] Calc: Multiply time (hours) with a float

2016-09-19 Thread Karl Voit
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 wrote: > Hello, > > Michael Welle writes: > [...] >> #+TBLFM: @2$3='(* $2 (org-time-string-to-hours "$1"));L > or converting $2 to a number be

Re: [O] Calc: Multiply time (hours) with a float

2016-09-18 Thread Michael Welle
Hello, Michael Welle 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 ;). Regards hmw

Re: [O] Calc: Multiply time (hours) with a float

2016-09-18 Thread Michael Welle
Hello, Karl Voit writes: > * Michael Welle wrote: [...] > ... which is working: > > | time [h:m:s] | value | hours [float] | product | > |--+-+---+---| > | 09:15:00 | 2.54321 | 9.25 | 23.524693 | > > #+TBLFM: $4=$2*$3::@2$3='(org-time-str

Re: [O] Calc: Multiply time (hours) with a float

2016-09-18 Thread Karl Voit
* Michael Welle wrote: > Hello, Hello Michael, > Karl Voit writes: > >> * Karl Voit wrote: >>> Hi! >>> >>> I do have following situation: I'd like to multiply a float with hours >>> which results in an error, obviously. However, I was not able to find >>> out how to do it. >>> >>> Minimal exam

Re: [O] Calc: Multiply time (hours) with a float

2016-09-11 Thread Michael Welle
Hello, Karl Voit writes: > * Karl Voit wrote: >> Hi! >> >> I do have following situation: I'd like to multiply a float with hours >> which results in an error, obviously. However, I was not able to find >> out how to do it. >> >> Minimal example with expected product: >> >> | time [h:m:s] |

Re: [O] Calc: Multiply time (hours) with a float

2016-09-11 Thread Karl Voit
* Karl Voit wrote: > Hi! > > I do have following situation: I'd like to multiply a float with hours > which results in an error, obviously. However, I was not able to find > out how to do it. > > Minimal example with expected product: > > | time [h:m:s] | value | h * value | > |--+-

[O] Calc: Multiply time (hours) with a float

2016-09-08 Thread Karl Voit
Hi! I do have following situation: I'd like to multiply a float with hours which results in an error, obviously. However, I was not able to find out how to do it. Minimal example with expected product: | time [h:m:s] | value | product | |--+-+---| | 09:15:00 |