Hi Bastien,
Bastien wrote:
> "Sebastien Vauban" writes:
>
>> Let's come back to time values:
>>
>> @2$2=1:23;t
>>
>> means, for me, that:
>>
>> - the value 1:23 should be assigned to the cell
>> - that value should be formatted as a fraction.
>>
>> Hence, I'd expect to see `1.38' (and not `0:00'
Hi Sébastien,
"Sebastien Vauban"
writes:
> Let's come back to time values:
>
> @2$2=1:23;t
>
> means, for me, that:
>
> - the value 1:23 should be assigned to the cell
> - that value should be formatted as a fraction.
>
> Hence, I'd expect to see `1.38' (and not `0:00').
This works correctl
Hi Bastien,
Bastien wrote:
> "Sebastien Vauban" writes:
>
>> We can assign the value "0:00" to a cell via the string function:
>>
>> | Task| HH:MM |
>> |-+---|
>> | This| 1:23 |
>> | Nothing | 0:00 |
>> | That| 4:56 |
>> #+TBLFM: @2$2=1:23::@3$2=string("0:00")::@4$2=stri
Hi Sébastien,
"Sebastien Vauban"
writes:
> We can assign the value "0:00" to a cell via the string function:
>
> | Task| HH:MM |
> |-+---|
> | This| 1:23 |
> | Nothing | 0:00 |
> | That| 4:56 |
> #+TBLFM: @2$2=1:23::@3$2=string("0:00")::@4$2=string("4:56")
>
> but, *
Hi,
Carsten Dominik wrote:
> On 20.3.2012, at 14:59, Sebastien Vauban wrote:
>>
>> As shown by this example, we can't assign the value "0:00" to a cell:
>>
>> | Task| HH:MM |
>> |-+|
>> | This| 1:23 |
>> | Nothing | #ERROR |
>> | That| 1:23 |
>> #+TBLFM: @2$2=1:2
Hi Sebastien,
you can use @3$2=string("0:00")
- Carsten
On 20.3.2012, at 14:59, Sebastien Vauban wrote:
> Hello,
>
> As shown by this example, we can't assign the value "0:00" to a cell:
>
> | Task| HH:MM |
> |-+|
> | This| 1:23 |
> | Nothing | #ERROR |
> | That
Hello,
As shown by this example, we can't assign the value "0:00" to a cell:
| Task| HH:MM |
|-+|
| This| 1:23 |
| Nothing | #ERROR |
| That| 1:23 |
#+TBLFM: @2$2=1:23::@3$2=0:00::@4$2=4:56
Best regards,
Seb
--
Sebastien Vauban
