Re: [O] Conditional in table formula with times

2014-02-24 Thread Loris Bennett
Hi Eric, Eric S Fraga writes: > Hi, > > Have you tried the numeric equivalent of your times? I believe the if > expression is interpreted as returning a number of seconds. The > following table format line works for me: > > #+TBLFM: $4=$3-$2;T::$5=if($4 > 0,29880,0);T::$6=$4-$5;T > > HTH, > er

Re: [O] Conditional in table formula with times

2014-02-24 Thread Eric S Fraga
Hi, Have you tried the numeric equivalent of your times? I believe the if expression is interpreted as returning a number of seconds. The following table format line works for me: #+TBLFM: $4=$3-$2;T::$5=if($4 > 0,29880,0);T::$6=$4-$5;T HTH, eric -- : Eric S Fraga (0xFFFCF67D), Emacs 24.3.1,

Re: [O] Conditional in table formula with times

2014-02-21 Thread Sebastien Vauban
"Loris Bennett" wrote: > "Sebastien Vauban" writes: >> "Loris Bennett" wrote: >>> "Sebastien Vauban" writes: "Loris Bennett" wrote: > I'm trying to keep track of total time spend at work, but I am having > trouble with a conditional in table formula: > > | *Day*| *

Re: [O] Conditional in table formula with times

2014-02-21 Thread Loris Bennett
"Sebastien Vauban" writes: > "Loris Bennett" wrote: >> "Sebastien Vauban" writes: >>> "Loris Bennett" wrote: I'm trying to keep track of total time spend at work, but I am having trouble with a conditional in table formula: | *Day*| *Came* | *Went* | *Worked* | *Re

Re: [O] Conditional in table formula with times

2014-02-21 Thread Sebastien Vauban
"Loris Bennett" wrote: > "Sebastien Vauban" writes: >> "Loris Bennett" wrote: >>> I'm trying to keep track of total time spend at work, but I am having >>> trouble with a conditional in table formula: >>> >>> | *Day*| *Came* | *Went* | *Worked* | *Required* | *Diff* | >>> |---

Re: [O] Conditional in table formula with times

2014-02-21 Thread Loris Bennett
Hi Seb, "Sebastien Vauban" writes: > "Loris Bennett" wrote: >> I'm trying to keep track of total time spend at work, but I am having >> trouble with a conditional in table formula: >> >> | *Day*| *Came* | *Went* | *Worked* | *Required* | *Diff* | >> |--++---

Re: [O] Conditional in table formula with times

2014-02-21 Thread Sebastien Vauban
"Loris Bennett" wrote: > I'm trying to keep track of total time spend at work, but I am having > trouble with a conditional in table formula: > > | *Day*| *Came* | *Went* | *Worked* | *Required* | *Diff* | > |--+++--++--| > |

[O] Conditional in table formula with times

2014-02-20 Thread Loris Bennett
Hi, I'm trying to keep track of total time spend at work, but I am having trouble with a conditional in table formula: | *Day*| *Came* | *Went* | *Worked* | *Required* | *Diff* | |--+++--++--| | [2014-01-06 Mon] | 8:00 |