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

[Michael Welle]

Hello,

Nick Dokos <address@hidden> writes:

> Michael Welle <address@hidden> writes:
>
>> Hello,
>>
>> Karl Voit <address@hidden> writes:
>>
>>> * Michael Welle <address@hidden> wrote:
>>>>
>>>> Karl Voit <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":
>>>> strange. I use the current Org version from git and Emacs 25.1.
>>>>
>>>>> | 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 ;). This empty line, that we see between the table above
and the formula, does that exist in your real Org file? If so, and if
the point is on the formula when you press C-cC-c, the table doesn't
change, i.e., the error mark doesn't go away even if the formula is
correct. 

Regards
hmw