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-24 Thread Loris Bennett
Hi Eric, Eric S Fraga e.fr...@ucl.ac.uk 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

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* | |--+++--++--| |

Re: [O] Conditional in table formula with times

2014-02-21 Thread Loris Bennett
Hi Seb, Sebastien Vauban sva-n...@mygooglest.com 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: 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
Sebastien Vauban sva-n...@mygooglest.com 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: [O] Conditional in table formula with times

2014-02-21 Thread Sebastien Vauban
Loris Bennett wrote: Sebastien Vauban sva-n...@mygooglest.com 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* |

[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 |